Thank you, Pete. This was a great recommendation that included additional
color functions that we might find useful down the road. Thank you for
sharing this information with us.

Sincerely,
Richard

************************
"Pete_UK" wrote in message
...
There are no in-built functions to do this.

However, Chip Pearson shows how it can be done with a bit of VBA he

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

Hope this helps.

Pete

On Jan 28, 2:51 am, "Blue Max" wrote:
Can anyone recommend a good formula for counting the cells of a common
color
in a range?

We have a color-coded visual schedule, but need to count the cells of a
common color to determine if we have allocated enough resources to a
particular task. Please note that the assigned colors are related to a
certain task (in a legend) and are often custom colors not chosen directly
from the standard palette.