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

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

Is it possible to add a formula that counts the number of non-blank rows
regardless of content?

I could then count the rows to below the bottom of table and the
formula would keep it up to date if extra rows are added.

Ian


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