ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Count only cells with red font. (https://www.excelbanter.com/excel-programming/436255-count-only-cells-red-font.html)

Cassie

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


All times are GMT +1. The time now is 11:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com