CourtneyG298
New Member
I work for a city police department and am responsible for doing verifications for sex offenders which occur yearly in the window of 30 days before/after the offender's birthday each year. The offender is responsible to contacting me to schedule an appointment but I am trying to create a worksheet to help track who should be calling me to do so and who is past due. I have created a worksheet that has a column (G) with their next verification date and would like for the entire row to be highlighted as follows:
Yellow for offenders within their 60 day window (30 days before to 30 days after their verification date)
Red for offenders past their 60 day window (more than 30 days after their verification date)
Below is a basic outline of what I am making. I want the entire row to be highlighted yellow if TODAY is between 30 days before the value in column G and 30 days after that value. I then want it to be highlighted red if TODAY is more than 30 days past the date in column G.
I have tried different conditional formatting formulas but cant seem to get it right.
All information is completely made up for learning purposes.
Yellow for offenders within their 60 day window (30 days before to 30 days after their verification date)
Red for offenders past their 60 day window (more than 30 days after their verification date)
Below is a basic outline of what I am making. I want the entire row to be highlighted yellow if TODAY is between 30 days before the value in column G and 30 days after that value. I then want it to be highlighted red if TODAY is more than 30 days past the date in column G.
I have tried different conditional formatting formulas but cant seem to get it right.
All information is completely made up for learning purposes.
