Excel Color Recognition Formula

[tanner.robin]

Is there a way to count a cell based on it's color? I have a series
of scores that I track for the month and I want to count any cells
that are gray. I can't figure out a formula that will do this for
me. Does anyone have any ideas? Feel free to email me at
(e-mail address removed) if you know how to do this.

Thanks.

R. Tanner

 

[Pete_UK]

Take a look at Chip Pearson's site:

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

Hope this helps.

Pete

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html

--
---
HTH

Bob


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