Macro to validate a condition and change cell color

[kapil]

Hi,

Can someone help me with the below code. I want the macro to validate the following two conditions and if both the the conditions are met it should change the cell color format to White.

Conditions are:
1. If Cel.Interior.ColorIndex = 50
2. And If Cel.Value is Not Equal to "(blank)"

Then it should change the Cell Color to White. I have written the following code but its not working. Please help. Thanks.

    For Each Cel In Range(Range("D6"), Range("D" & Range("B" & Rows.Count).End(xlUp).Row))
        If Cel.Interior.ColorIndex = 50 And Cel.Value Is Not "(blank)" Then
            Cel.Interior.ColorIndex = 2