Highlighting

[Zycho]

Hi! Question.. I have got store list on B3:B7, dates when the vehicle changes for the store on D3:D7, vehicle registrations drop down list on F3:F7 and when the next change is due required on H3:H7.. now what I want to do is if the same vehicle is used for the same store 4 days in a row to be highlighted red in the next change due row and no change at all if no vehichle is selected. I can't work it out how to do that as I'm pretty new at doing all that on excel. Thanks in advance!

https://drive.google.com/file/d/1o8jaH5q-mNnLUer1PCOG78bFMafNn1Ti/view?usp=drivesdk

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1062329-highlighting-dates.html#post5102219

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.