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
|