countif based on fill color
 

Can anyone tell me how to do a countif based on cell fill color? I want to
count all cells I've filled in red.

countif based on fill color
 

Not possible with built in functions unless you can use the criteria which
made you colour them in the first place, otherwise you will need code,
either a macro or a UDF

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

--
Regards,

Peo Sjoblom

Portland, Oregon




"edmcf@mot" wrote in message
...
Can anyone tell me how to do a countif based on cell fill color? I want to
count all cells I've filled in red.