Hi again,
another suggestion. I would add a column between "H" and "I", which indicates if you hace actually "stopped" the advertising (enter "Yes" manually here if you have "stopped" it).

Then I would use this column the enhance the conditional formatting for the date check (red, green, yellow), to avoid a "red" to appear if you already have "stopped" the advertising (= "the new column has a YES in it").

I hope this explanation was clear, just tell me otherwise!



Kind regards
Bjorn

First suggestion that looks excellent, i was playing around and using a more updated spreadsheet than id uploaded. wondered why it wouldnt do anything for me. certainly gonna cut down amount of data input, which obviously Id be duplicating. im well impressed. gonna look at your second bit now

hmm i've just been thinking.

ok advertising on a vehicle is going to start and finish. and then another one start start to maximise revenue.

If I change the Start and End/Due Date for the next advertising. It deletes the X's from the Calendar bit and complete teh new bit.
It would be beneficial to keep that so can keep track of who advertised and when.

Unless when one is ending I could somehow send to Archive the info on that truck to another sheet and simply go ahead and change the Start/Due Dates for the next advert

Archive Reg, Start, Due Date, Duration and I enter who advertised manually