Hi
you need VBA. There's no worksheet formula for this

--
Regards
Frank Kabel
Frankfurt, Germany

"Duncan Help" schrieb im
Newsbeitrag ...
Can I do this as a function in Excel, I believe the link shows ways
to do it
in VB. Basically I have a range of cells, and I want to TRUE or
FALSE answer
as to whether any of them are RED.

"Frank Kabel" wrote:

Hi
see:
http://www.xldynamic.com/source/xld.ColourCounter.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Duncan Help" schrieb im
Newsbeitrag
...
Is there a way I can detect if any cell is a certain color in a
range
of cells?