Excel 2002--counting colored cells

[djm]

Does anyone have a formula that I can use to count all of the colore
[eg: red] cells in a calendar?...Thank

 

[Norman Harker]

Hi djm!

You'll need VBA for this. But not to worry because it's all set out
at:

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Trevor Shuttleworth]

Look at Chip Pearson's site ... loads of stuff for working with colours

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

Regards

Trevor