Highlight Microsoft Excel boxes with different colors based on Dates

Job ID: 31993465

Budget: $10 – $30 USD

I'm looking to have Microsoft Excel boxes be highlighted Yellow 7 days before a date, Green after the date until the expiration date.
Then the next cell has the end date and it turns Orange when the becomes that date, and turns red 7 days after.
And, there should be an option to stop both cells have any color.
Related categories: Visual Basic Excel Excel VBA