You would need to write a VBA macro (UDF) that returns the font color, either
as a number or as text, and check the result of that function in your IF
statement.

If the font color is determined by conditional formatting, your formula can
use the same formula that you used in CF.

On Fri, 7 Jan 2005 20:21:02 -0800, "esha734"
wrote:

How do I determine the font color of a cell with an IF function?
This is how I would think its done (the following formula could be in B1):
IF A1=red,"RED","BLACK"
If the font color in A1 is red, then RED is printed in B1, otherwise BLACK
is printed in B1.
but this does not work. Any suggestions?