Thanks Peo.
Do you know how to get the formula to automatically refresh as I am
highlighting?

"Peo Sjoblom" wrote:

In Excel 2007 yes, in previous versions you would need VBA


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


--
Regards,

Peo Sjoblom



"Ted" wrote in message
...
Is there a way to count cells that have been highlighted similiar to using
the COUNTIF but instead of a variable checking for the formatting of a
cell?