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?

2 responses

Answer 1 / 2
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,
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

Similar discussions

Code to move rows into another sheet based on certain values
nathaliecannell -
vcoolio -

1 response
Macro to delete rows if cell contains string
jonny578 -
vcoolio -

1 response
Excel VBA copy and paste loop with logic condition
Yogibearv -
Yogibearv -

6 responses
Grey out an entire row in Excel 2010 depending on a cell's value
deeptis -
T -

11 responses
How to duplicate rows x number of times
carlos.guerrero18 -
ac3mark -

4 responses
Merge rows if it meets criteria in Excel
cacaip89 -
rizvisa1 -

6 responses