COUNTIF

[JT]

I'm trying to get a formula to work in a worksheet that will count the number
of cells in a row that contain red colored text. I just can't seem to get it
to work. Actually, I'm not even sure it's possible. The text that is in
these cells is of no signifigance, just that the color of it is red.

Any assistance in this puzzle will be GREATLY appreciated.

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.ColourCounter.html
and
http://www.cpearson.com/excel/colors.htm

not possible without using VBA