Conditional Formatting Due dates

[bluenose5709]

Hi,

Having trawled the internet and indeed this forum I am hoping that someone can help me....

I have a spreadsheet with 2-400 rows. Column A contains dates starting at row 2 (Row 1 has the column title) what i am trying to achieve is apply conditional formatting such that:

1. If the date has already passed shade the row cells Red
2. If the date is within the next 30 days shade shade the row cells Amber
3. If the date is within the next 60 days shade shade the row cells Cream

For all other rows to remain White.

I have tried many formulas using, for example the "TODAY" function but no matter what I apply it does not seem to work as intended.

Any and all help provided would be much appreciated.

Thank you,

Arran

 

[Joe4]

You will need three Conditional Formatting formulas:

1. Red:

=A2 < TODAY()

2. Amber:

=AND(A2 >= TODAY(),A2 <= (TODAY()+30))

3. Cream:

=AND(A2 > (TODAY()+30),A2 <= (TODAY()+60))

Note that you might have to play around with the ">",">=","<=", and "<" signs a little, depending on which color you want EXACTLY 30 or 60 days to be.

 

[bluenose5709]

@Joe4 Thank you. that seems to have worked a treat.

regards
Arran

 

[Joe4]

You are welcome.
Glad I was able to help!