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.
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.