You need a custom function for this. There is one at
http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DME" <craigjoseathotmaildotcom wrote in message
...
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.