There is no way within a formula to determine a cell's color,
either background or foreground. You need a VBA function. See the
"Returning The ColorIndex Of A Cell" on
www.cpearson.com/excel/colors.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Gary" wrote in message
...
I have seen this question in reverse on the forum. Usually the
question is
to change the font color when criteria is met.

I need to test the font color in order to determine value. I
can do it in
code with a for..next loop but I was wondering if it could be
done in an if
statement?

Example: If(fontcolor (A2) = "Red", then "Next Day",
"Standard")

What would be the syntax?

Thanks for the help.