count.if

[Giandomenico Rocchi]

Is there a way to count the number of cells in a range base on the
format of the cell?
I.e. in a range the number of red cells?
Thanks for any suggestions

gianni

 

[Frank Kabel]

Hi
see: http://www.cpearson.com/excel/colors.htm