Crosswords1 min ago
Excel formula to change colour of cells after time period
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!
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!
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.
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.