I'm working with deadlines, and projects need to progress from one stage to another by specific dates.
I have 3 deadlines:
A: Create BRD by date A
B: Get project estimated by date B
C: Begin project development by date C
I have a sheet where all projects are listed in rows where I change the project status (BRD created, project estimated, development started). What I want is for the row to change colors if the project hasn't change its status by the deadlines above.
Is this even possible?
If a cell has a certain value after certain date, color the row
Start by slecting all rows you want to apply the conditional format (CF) to and choose to use a formula in CF:
The column D reference refers to the project status column. Change to match yours.