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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Back
Top