Count only cells with red font.

Cassie · Nov 17, 2009

I am working with Excel 2003.
I currently have my data range set up to count only non-blank cells with a
counta function. However some of those cells contain gray font and others
contain red. How can I change my formula to count only non-blank cells that
have red font?

Dave Peterson · Nov 17, 2009

Start with Chip Pearson's site:
http://www.cpearson.com/Excel/colors.aspx

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Count only cells with red font.

Cassie

Dave Peterson