D djm Jan 12, 2004 #1 Does anyone have a formula that I can use to count all of the colore [eg: red] cells in a calendar?...Thank
Does anyone have a formula that I can use to count all of the colore [eg: red] cells in a calendar?...Thank
N Norman Harker Jan 12, 2004 #2 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 (e-mail address removed) Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes.
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 (e-mail address removed) Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes.
T Trevor Shuttleworth Jan 12, 2004 #3 Look at Chip Pearson's site ... loads of stuff for working with colours http://www.cpearson.com/excel.htm Regards Trevor
Look at Chip Pearson's site ... loads of stuff for working with colours http://www.cpearson.com/excel.htm Regards Trevor
