Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

If a cell has a certain value after certain date, color the row [Solved/Closed]

Report
-
 ManxMaggie -
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?

2 replies

Answer 1 / 2
Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
 462
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
Report

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
Answer 2 / 2
Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
 462
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
Report

I definitely had something wrong; your screen capture was super useful. Thank you so much for your time and assistance!!
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!