If and formatting

S

shank

Is it possible to use the IF statement to analyze a cell?
=IF(A1 = GoldColor, 1, 0)
I hope that makes sense. If cell A1 has a particular attribute, then 1 or 0.

thanks
 
Top