Total number of green cells
 

Hello all could you help please.


I have created a spreadsheet that logs staff holidays,
sick etc.
I am trying to total all cells in a row with certain
interior colour.

Many thanks if you can help

Paul G

Total number of green cells
 

Thanks Ron for the link.

Hes a very clever man, our Mr Pearson


-----Original Message-----
You will find your answer here Paul
http://www.cpearson.com/excel/colors.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Paul" wrote in message
...
Hello all could you help please.


I have created a spreadsheet that logs staff holidays,
sick etc.
I am trying to total all cells in a row with certain
interior colour.

Many thanks if you can help

Paul G


.