Counting Cells which are shaded a certain colour

[[email protected]]

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

[Paul B]

Paul, have a look here,

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

--
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

<[email protected]> wrote in message
news:[email protected]...
> 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
>

[[email protected]]

Thanks very much - exactly the sort of stuff I was looking for.

Paul

[Paul B]

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

<[email protected]> wrote in message
news:[email protected]...
> Thanks very much - exactly the sort of stuff I was looking for.
>
> Paul
>