How to fill in non-colored cells to gray

[dmb41]

I have several cells color-coded (based on frequency) but there are many white, non-colored, cells which I need to color gray.

Is there any way to color all these non-colored cells quickly, as I have many sheets to do.

Seems like an easy logic I just cant find a simple way to do it.

 

[jeffreybrown]

What do the white, non-colored cells have in them?

 

[dmb41]

Text w/ numbers (formatted as text) : i.e., 99833T67

 

[jeffreybrown]

You could apply conditional formatting with...

=ISTEXT(A1)

 

[dmb41]

Wouldn't that just fill in all the cells that have already been colored (a different color, through a java program) to gray?

I have something like the following:

(With different text in each)

A1 = RED B1 = BLUE
A2 = BLUE B2 = RED
A3 = NO COLOR B3 = RED
A4 = NO COLOR B4 = NO COLOR
A5 = NO COLOR B5 = NO COLOR

I am looking to color the cells (in this example: A3,A4,A5,B4,B5) gray and leave the existing cells a color.

I know I could just use CTRL and highlight all blank - but there is too many sheets...

Hope this helps clarify the issue.

 

[jeffreybrown]

With your test data this works.

Highlight range >> Alt + F8 >> ChangeColors >> Run

Sub ChangeColors()
    Dim cell As Range
    For Each cell In Selection
        If cell.Interior.Color = RGB(255, 255, 255) Then
            cell.Interior.ColorIndex = 16
        End If
    Next cell
End Sub

 

[dmb41]

Thank you! Exactly what I am looking for.

 

[jeffreybrown]

Thanks for the follow-up...glad it worked for you