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?
--
Have a great day! Thanks for your help!

Sincerely,
Cassie

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.)

Cassie wrote:
>
> 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?
> --
> Have a great day! Thanks for your help!
>
> Sincerely,
> Cassie

--

Dave Peterson