If selected date is within a month of current date, highlight the row

Hi, I have an excel spreadsheet that shows the details of CRB checks for staff / visitors to our school. I want the spreadsheet to look at the "Valid To" date and check to see if it is in one month of the current date, and if so highlight the row of the table.

Is this possible?

Thanks,