View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cassie Cassie is offline
external usenet poster
 
Posts: 47
Default Count only cells with red font.

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