formula to find out the color an excel cell is highlighted?

[Guest]

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?

 

[Peo Sjoblom]

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


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

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Thanks Bob,

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

 

[Guest]

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