Counting Cells which are shaded a certain colour

  • Thread starter Thread starter velodocuk
  • Start date Start date
V

velodocuk

Hello,
I have a spreadsheet set up as a year calender for booking annual leave
at work. Each staff member shades cells their own colour to book annual
leave.

I'd like to set up a function which counts the total number of cells
shaded a certain colour - so when someone adds leave, their own
personal running total is displayed.

Hence I need a formula which counts the total number of cells in the
worksheet which are a certain colour (using the standard palette).

I'd be very grateful if anyone could let me know if there's a simple
way to do this?

TIA for any help

Paul
 
Your Welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Back
Top