Hi,
I have column A with a bunch of deadlines, in the form of dates. Is it possible to show in column B which are either 'delayed' (i.e. deadline has passed), 'due within 30 days' and 'not due yet'?
Can I also lay conditional formatting over the top of Column B that I have a traffic light system operating? red = delayed, orange = due within 30 days and green = not due yet?
Thanks
Rowenah
Bookmarks