countif based on fill color

[edmcf@mot]

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.

 

[Peo Sjoblom]

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