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