Formula based on formatting?
 

Hi

Is it possible to create a formula based on the colour of a cell?

I'm trying to get automatically calculating cells on a holiday/sickness
database. Cells are yellow if holiday, brown if sick etc. So for the totals I
want the formula to + 1 for each yellow box and same for other colours.

Thanks in advance for any help.

Helen

Formula based on formatting?
 

If the colour is the result of Conditional formatting the use the same
conditions in nyour formula. If the colours are manually wntered then look
at:

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Helen J" <Helen wrote in message
...
Hi

Is it possible to create a formula based on the colour of a cell?

I'm trying to get automatically calculating cells on a holiday/sickness
database. Cells are yellow if holiday, brown if sick etc. So for the
totals I
want the formula to + 1 for each yellow box and same for other colours.

Thanks in advance for any help.

Helen