You need a VBA function. See www.cpearson.com/excel/colors.htm
for example code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"snowing"
wrote in message
...

hello,

Does anyone know how you could count only the rows where the
cells data
has a font color of red ?
I need to add something like this to a macro.

thanks,


--
snowing
------------------------------------------------------------------------
snowing's Profile:
http://www.excelforum.com/member.php...o&userid=34576
View this thread:
http://www.excelforum.com/showthread...hreadid=547273