Count with formatting
 

Hi,
I have used to styles which are pre-defined in office 2010 :) one of them is
greeny one named Good and yellowish one named Note.
I would like to count the rows styled/formatted with these ones.

I want to spesify the range( lets say $E1:$E256) then want to see
how many cells are formatted with Good style or Note Style.
thank you in advance

Count with formatting
 

Hi,
see CPearson web

http://www.cpearson.com/excel/colors.aspx

hope this helps

"mns" wrote:

Hi,
I have used to styles which are pre-defined in office 2010 :) one of them is
greeny one named Good and yellowish one named Note.
I would like to count the rows styled/formatted with these ones.

I want to spesify the range( lets say $E1:$E256) then want to see
how many cells are formatted with Good style or Note Style.
thank you in advance