View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Helen J Helen J is offline
external usenet poster
 
Posts: 1
Default 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