Similar but different conditional formatting question

Copper Contributor

Hello all,

I have a spreadsheet with expiration dates that I would like to highlight either yellow if the due date is between 31-60 days out from the due date and red if it is 0-30 days out from the due date.

 

Everything I have seen for resolutions involves a TODAY() function and today's date doesn't make any difference in this spreadsheet.

 

Can anyone help please?

Thank you,

Buffy

1 Reply

Hello @BuffyBriggs_1187,

 

You could apply the following conditional formats as formulas:

 

Assuming your date is in cell A2 and your due date is in cell B2:

For dates between 0 and 30 from the due date (RED):

=AND(B2-A2<=30,B2-A2>=0)

 

For dates between 31 and 60 from the due date (YELLOW):

=AND(B2-A2>=31,B2-A2<=60)

You may then apply this conditional format to your range of cells.

 

Hope this helps!
PReagan