=IF Color

[Jeff-B]

Is there a way to use the color of a cell in an IF statement?

 

[FSt1]

hi
since you post in programming, i assume you are looking for a code solution
and not a formula solution.

Sub JeffBIfColor()
If Range("G4").Interior.ColorIndex = 3 Then 'red
MsgBox "it's red"
Else
MsgBox "it's not red"
End If

End Sub

regards
FSt1

 

[Jeff-B]

Thank you so much I will give it a try. I didn't think a formula solution
was possible so I thought I would have go the programming route. Is there an
easy formula solution?

 

[Gord Dibben]

There is no formula solution using Excel's built-in functions.

If the color is due to Conditional Formatting you could use the IF function
based upion the condition.

Elsewise you need a macro or a UDF


Gord Dibben MS Excel MVP