Good Morning.
I am working with certificate expiry dates and want to have conditional formatting to highlight as the expiry dates get closer and/or is past due.
Here is what my need is:
If (DATE)E9 is equal to A1(Current date) or greater, then turn the cell Red
IF (DATE)E9 is less than (DATE)A1-30(DAYS), but greater than (DATE)A1 then turn the cell Pink
IF (DATE)E9 is less than (DATE)A1 minus 90(DAYS) AND greater than (DATE)A1 minus 30(DAYS) then turn the cell Yellow
If (DATE)E9 is greater than (DATE)A1 minus 90(DAYS) then turn the cell Green.
Thanks for the assistance!