Counting colour formatted cells
 

Is there a function which allows me to count the cells which are shaded in
yellow ?

Counting colour formatted cells
 

try

http://www.cpearson.com/excel/SortByColor.htm

regards from Brazil
Marcelo

"Hood" escreveu:

Is there a function which allows me to count the cells which are shaded in
yellow ?

Counting colour formatted cells
 

Chip Pearson has a function on his site to do exactly that:

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

=CountbyColor()


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=554973