Hi

Have a look he
http://www.cpearson.com/excel/colors.htm

Andy.

"Rob" wrote in message
...
I have a spreadsheet that contains pasted data from an online database.
The
imported cells are color coded with RED, YELLOW, and GREEN fill. I would
like an automated way to calculate the number of RED, YELLOW, and GREEN
cells
in the data. Any thoughts?