Solved how to turn a cell a certain color 5 days before date in cel

February 25, 2015 at 13:14:47
Specs: Windows 7
Is there a way to turn a cell in excel a certain color 5 days before the date entered in the cell? Example: I have a spread sheet of orders from vendors with a due date in the last column. I would like the cell with the due date in it to trun red 5 days before the due date. Can anyone help?
excel version - 14.0.7143.5000
win 7

See More: how to turn a cell a certain color 5 days before date in cel

Report •

#1
February 25, 2015 at 13:42:24
✔ Best Answer
Read this How-To

http://www.computing.net/howtos/sho...

It should explain how to accomplish what you want.

MIKE

http://www.skeptic.com/


Report •

#2
February 26, 2015 at 05:08:24
Thank you. Perfect. Exactly what I was looking for

Report •
Related Solutions


Ask Question