As far as I know, you cannot test font color with a worksheet function. You
can do so in VBA code like
If Range("B1").Font.ColorIndex = 3 Then
Range("C1") = 1
End If

If the font color in B1 is controlled by conditional formatting, you could
set up a similar test for value in C1.

Lets say you used Conditional Formatting in B1 to set font color to red when
its value is greater than 100, then in C1 you could use similar logic with an
IF function:
=IF(B1100,1,0)



"im-EGY" wrote:

Can I set a cell to equal 1 for a font colored "RED" in another cell , such as:
if cell B1 is "RED" font colored i need cell C1 to be =1
Thanks