Good evening,
I am working on a tracker for work and am running into an issue that google has not been able to help me with. I want to conditional format using colors (red, yellow, green) for a cells date, based on another cells date. The two dates are based on a year for being overdue. If the date it was inputted on shows 9/3/2021 then it is set to expire on 9/3/2022. The example is listed below
Column F / Column G
F1: Posicheck On | G1: Test Due
F2: 9/3/2021 | G2: 9/3/2022
I want to turn cell G2 turn red when it passes the date in F2, turn yellow when it is within 30 days of F2, and remain green if it has more than 30 days till it passes F2. If need be I can also post a screenshot, I just unfortunately cannot at this time because I am not at work. I greatly appreciate whatever assistance can be provided as I worked on this for about 4 hours with no luck.
Bookmarks