Conditional formatting using dates

[rkobrya]

1) I have a 'to-do' list with a column of 'date due' (column D)... I need to set up conditional formatting on that column so the things that are past due are red, due today are green, due tomorrow are yellow.


2) And the column 'E2 and on' next to that has 'not started/pending/complete' when it is at complete I need it to become green as well.


So there should be 3 conditional formulas total (or 2).


3) Is it possible to make the 'description' (column C) column change color as well based on the 'due date' column?


additional info: My 'today's date' is in E1.

 

[kaushik03]

Hi Rkobrya,


Do you think it is helpful for you?


http://chandoo.org/wp/2012/05/22/highlight-due-dates-excel/


Kaushik

 

[sdsurzh]

Hi,


Can you please download the below and check.


http://www.2shared.com/file/3a8UaoMF/4_online.html


Thanks,

Suresh Kumar S

 

[rkobrya]

Those responses answered my question. Thank you very much!