Thread: [Solved] Advice on my Excel Project
View Single Post
 
Old 12-28-2010, 12:01 PM
BjornS BjornS is offline Windows Vista Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

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
Reply With Quote