Conditional Formatting depending on whether a cell is blank or not

[Don Owens]

I am building a spreadsheet for my boss to track some dates. I would like for Due Date cell to fill yellow when Completed cell is empty and today is 7 days prior to the Due Date. I would like for Due Date cell to fill red when D4 is empty and today is the due date. If Completed cell is populated, nothing should occur in Due Date cell as the dates come and go. Thanks for any help!!

Due Date Completed

11/5/2014 10/27/2014
11/4/2014
11/6/2014 11/1/2014
11/7/2014
11/7/2014 11/5/2014
10/31/2014 10/31/2014
10/30/2014 11/1/2014

[etaf]

I would like for Due Date cell to fill red when D4 is empty and today is the due date

use a conditional formatting formula
=AND(D4="", C4=today() ) - for RED

I would like for Due Date cell to fill yellow when Completed cell is empty and today is 7 days prior to the Due Date.

=AND( D4="", C4 = today()+7 )
format yellow
that will only work for the 7th Day

you can change the C4 value to be > or < if you want a range of days

perhaps attach a sample spreadsheet with expected results coloured

[Don Owens]

etaf,

Your solution appears to be working just fine!!! Thank You so much, I really appreciate it. If I can figure it out, I will most certainly enhance your reputation!!

[etaf]

your welcome and thanks for the Rep