Countif criteria based on cell's fill colour

[Mark Keeffe]

Is it possible to base a criterion for a function like
Countif on the fill colour of the cells in the specified
range?

 

[Paul]

Is it possible to base a criterion for a function like
Countif on the fill colour of the cells in the specified
range?

This needs VBA code; it cannot be done with worksheet functions. Look here
for full details:
http://www.cpearson.com/excel/colors.htm