Using VBA to change font color

[robertdseals]

hello,
I have a large spreadsheet with cells of different colors. They also have wording in black. I would like to wording to be the same color as the background so I don't see the words. How can I change the font on thousands of cells to match the background?

 

[Darren Bartrup]

Hi,

You could use:

Sub test()

    Dim rCell As Range
    
    For Each rCell In Selection
        rCell.Font.Color = rCell.Interior.Color
    Next rCell


End Sub

Which will change the font colour to the background colour.

OR

you can give the cells a custom number format of ;;; which will hide everything except error values.

 

[robertdseals]

The ;;; worked for me. Thanks!