Aug 14 2019 11:15 AM
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
Aug 14 2019 01:12 PM
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