Highlighting dates

[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!

 

[RasGhul]

Its based on current date, is there 4 vehicles & stores matched in the last 4 days?

It's working on this sheet;

https://docs.google.com/spreadsheets/d/1jZowGfLklOw1lx4kjhBA6Qrd9P6l_f3JBA_DSi8YJjI/edit?usp=sharing

 

[Zycho]

Its based on current date, is there 4 vehicles & stores matched in the last 4 days?

It's working on this sheet;

https://docs.google.com/spreadsheets/d/1jZowGfLklOw1lx4kjhBA6Qrd9P6l_f3JBA_DSi8YJjI/edit?usp=sharing

This is really similar to what I need.
But I don't want to be adding same store every time I use it few days in a row.
What I want is just those 5 stores to be there and I want to manually change the dates everyday if I use the same vehicle for the same store.
To simplify that, I want change due column to go red if I haven't changed the same vehicle for the same store 4 days in a row.
Thanks a lot for that, appreciate it!

 

[RasGhul]

Ok we're getting close.

So all the stores column will be fixed, and you will change the dates manually.

For example if the same rego at any store becomes 4 days old, then the change due column goes red.

 

[Zycho]

Ok we're getting close.

So all the stores column will be fixed, and you will change the dates manually.

For example if the same rego at any store becomes 4 days old, then the change due column goes red.

Yes this is exactly what I need

 

[RasGhul]

Zycho,


Highlight the H Column

Conditional Format/Formula where true/Format Red

=AND(ISNUMBER($D1),$D1<=TODAY()-4)

In the CF rules manager "Applies to" should read;

=$H:$H

 

[Zycho]

Zycho,


Highlight the H Column

Conditional Format/Formula where true/Format Red

=AND(ISNUMBER($D1),$D1<=TODAY()-4)

In the CF rules manager "Applies to" should read;

=$H:$H

That's it! Thank you so much for that sir. Wish I knew as much as you do. Still learning though!
Have a fantastic day!

 

[RasGhul]

Your welcome