Condition Formatting based on due date

J

jaggy

I have a spreadsheet where I am trying to color a row based on how
close I am to a due date.

The basic logic is:
I need to color a row yellow if today's date is less than 45 days from
the due date in column B or color the same row red if today's date is
less than 14 days from the due date in column B.

I am stumped, any suggestions would be greatly appreciated.

Thanks,
jaggy
 
G

Guest

Select the entire sheet (A1 active), then apply the CF as

Cond1:
=AND($B1<>"",$B1-TODAY()<14)
Format: Red fill

Cond2:
=AND($B1<>"",$B1-TODAY()>=14,$B1-TODAY()<45)
Format: Yellow fill
 
J

jaggy

Max - Thanks that did it.
Max said:
Select the entire sheet (A1 active), then apply the CF as

Cond1:
=AND($B1<>"",$B1-TODAY()<14)
Format: Red fill

Cond2:
=AND($B1<>"",$B1-TODAY()>=14,$B1-TODAY()<45)
Format: Yellow fill
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel due and overdue date colours 2
Conditional Formatting based on dynamic Date 1
Cell Fill Color 1
Conditional Formatting 5
PLEASE HELP! need conditional formatting related to date, blank cellsand today's date 16
Conditional Formatting Based on Due Dates 3
Oh god someone help me please. This is ridiculous. 1
Help to Highlight Excel Row based on Weekly Date Range 2

Top