If a cell has a certain value after certain date, color the row
Solved/Closed
Related:
- Excel conditional formatting highlight row if cell contains text
- Conditional formatting if cell contains text - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Highlight cell if another cell contains any text ✓ - Excel Forum
- Count if cell contains number - Excel Forum
- Excel date format dd.mm.yyyy - Guide
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
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
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
Jun 22, 2016 at 08:09 AM
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