COUNTIF(B2:V2),"*" AND Font.ColorIndex=1??

G

Guest

I want to count any character in a row, only if it's font colour is black.
Or put it another way, I want to count the number of characters in a row,
only if their font colour is not light green (or whatever colour I choose).
I do not want to count blank cells either.
Any ideas out there much appreciated.
Excel 2003, Office XP.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about conditional formatting of zeros in Excel 0
Count Font Colour 1
if cell starts with characters formula 3
Selecting specific cells in a column using countif 1
Border 1
Sorting and COUNTIF 6
Excel Excel 2013 conditional formatting 1
Counting how many numbers and letters appear in a particular row 7

Top