Hello, I’m trying to apply conditional formatting to the table in the attached. Columns E & F contain planned start and finish dates. Column G contains a status (Planned, In Progress, Complete). I would like to apply a conditional format to column G such that it is highlighted if not “Complete” AND if the finish date is in the past.
I’ve been attempting to do this but not successfully and would appreciate somebody’s help with it please.
Thank you,
Jess
Bookmarks