Thread: If Statement
View Single Post
  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Not built in, but there are ways using VBA

http://www.cpearson.com/excel/colors.htm


Regards,

Peo Sjoblom

"DME" wrote:

Is there a way to produce an IF statemnt that relates to the Fill Color of a
Cel. For instance IF(the Fill Color of A1 = Red, then I want B2 * C2, IF
not then b2 *d2) .

I thought I saw something in this newsgroup beefore on this but I was unable
to find it.

Thanks in advance for help.