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