Formula based on formatting?

H

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
 
S

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Holiday and sick leave records 1
create a formula based on cell color 2
cell vlue based on cell back colour 6
Not enough conditional formatting 2
Conditional format a column based on value in a different column 3
conditional formatting update issue 5
conditional formatting based on different cells with more conditio 1
Formula for Dates and CF Colour then convert to Text 3

Top