Logical Test comparison using cell color

[chamuko]

I'm using Excel 2002 and trying to use the IF function to see if a cell color
is RED; something like the following:

IF (B3=RED,"X","Y")

So if cell B3 is colored RED then display X otherwise Y

 

[ShaunM]

Hi

Here is thread that I asked a similar question in sometime ago, I thin
it will answer your question perfectly.

http://www.excelforum.com/showthread.php?t=381460

Cheers

Shau

 

[RagDyer]

Is the cell colored by means of "Conditional Formatting"?

If so, mimic the conditions, or post them here for suggestions.