If a cell has a certain value after certain date, color the row
Solved/Closed
Related:
- Highlight row if cell contains date
- Count if cell contains number - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Highlight cell if another cell contains text - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
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