If a cell has a certain value after certain date, color the row

ManxMaggie - Jun 21, 2016 at 11:09 AM
 ManxMaggie - Jul 18, 2016 at 05:13 AM

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?

2 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 21, 2016 at 11:49 AM
Hi ManxMaggie,

Start by slecting all rows you want to apply the conditional format (CF) to and choose to use a formula in CF:
=AND($D2="BRD created",$A2<TODAY())
=AND($D2="project estimated",$B2<TODAY())
=AND($D2="development started",$C2<TODAY())

The column D reference refers to the project status column. Change to match yours.

Best regards,
Hi TrowaD,

Thanks for your reply. I'm afraid this didn't work; it's highlighting cells where the value is different to the specified one. e.g. BRD created formula is highlighting project estimated.