Inspction Due Date Range Window - Conditional Formatting

[rhoover7420]

I am working with Inspections Dates and I have a range of dates to work within to have these inspections completed. I am trying to format the cells that contain the due dates to where they will change color when I am in the due date range window to execute these inspections. See the attached excel sample file.

Hopefully I have given enough information to where someone can help me with the conditional formatting.

I appreciate any help.

Regards,
Ray