Formula based on formatting?

  • Thread starter Thread starter Helen J
  • Start date Start date
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
 
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

Using SUM function to count hours BUT ignore Letters? 6
Holiday and sick leave records 1
formula based on text information 2
Not enough conditional formatting 2
Formula for Dates and CF Colour then convert to Text 3
create a formula based on cell color 2
Trying to calculate hours worked on timecard using "IF" command 6
Quday-Conditional Formatting 5

Back
Top