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