Previous Topic Next Topic

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

Solved/Closed
ManxMaggie - Jun 21, 2016 at 11:09 AM
 ManxMaggie - Jul 18, 2016 at 05:13 AM
Hello,

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?
Related:

2 replies

Answer 1 / 2
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
 514
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,
Trowa
0
ManxMaggie
Jun 22, 2016 at 08:09 AM
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.

Thanks
0
Answer 2 / 2
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
 514
Jun 27, 2016 at 09:30 AM
Hi ManxMaggie,

Then I'm afraid you did something wrong. I repeated the steps and created a screenshot. Maybe you spot something that is different in your scenario (apart from the language):


Best regards,
Trowa
0
ManxMaggie
Jul 18, 2016 at 05:13 AM
I definitely had something wrong; your screen capture was super useful. Thank you so much for your time and assistance!!
0