Hi Everyone,
I am trying to conditionally format a column of dates where the cell changes colour dependent on how much time is pending or elapsed from todays date. I have tried to attach a picture but if that hasn't worked I need:
DATE WITHIN 3 MONTHS OF TODAY AMBER
THE DATE PASSED UP TO 3 MONTHS AGO RED
DATE PASSED OVER 3 MONTHS AGO DARK RED
DATE IS OVER 3 MONTHS IN FUTURE GREEN
excel pic.jpg
I hope that makes sense,
Thank you,
Rosie
Bookmarks