Formula based on formatting?

[Helen J]

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

 

[Sandy Mann]

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk