Counting cells based on color

[djm]

I am looking for a "counting" formula that will count cells in a rang
based on their color, so that if I color a series of dates (to sho
'vacation) the number of cells (days) will be counted...to keep trac
of vacation...thanks

 

[Jason Morin]

There's no built-in functionality for that - it requires
a UDF (user-defined function). You'll find several
examples in the google archives:

http://www.google.com/advanced_group_search?
as_ugroup=*excel*&lr=&num=100&hl=en

MVP Chip Pearson also has some code:

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

HTH
Jason
Atlanta, GA