Excel formula to change colour of cells after time period

Vindleson | 10:52 Mon 29th Dec 2008 | Computers

0 Answers

Can anyone help? Meant to have sussed this before I get back to work but I'm stuck!

I've got a set of cells in excel with dates in them. I need to try and make up a formula that will change the colour of the cell when a certain number of days has passed. (i.e. cell dated 1/1/09 needs to change orange when 30 days have passed and turn red after 60 days have passed).

Can anyone help or I think I'll be doing this on New Years Eve!

picture has shrunk

laptop problem

Answers

Best Answer

Nobody has yet answered this question. Once some answers have been given, Vindleson will be able to select one answer as the best. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

There are no answers available for this question.

Do you know the answer?