I need help on creating formula in excel 2007.
Situatiion is .... Say cell A1 is coloured as Red. I need to put a formula in cell B1, where the result should be "Yes" if the color of cell A1 is Red. and "No", if the colour of the cell A1 is anyother or none.
If you are looking for a formula, I am not sure if there is any inbuild excel formula to do that. You can create your own function to do that
Public Function dispColorIndex(targetCell As Range) As Variant
Dim colorIndex As Long
colorIndex = targetCell.Interior.Color
If (colorIndex = 255) Then
dispColorIndex = "YES"
dispColorIndex = "NO"
as per your example , in b1 enter