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?
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):
For dates between 31 and 60 from the due date (YELLOW):
You may then apply this conditional format to your range of cells.
Hope this helps!PReagan