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 clear formatting - Guide
- How to use conditional format based on text? ✓ - Excel Forum
- Excel add 1 if cell contains text ✓ - Excel Forum
- If i highlight a close friend story - Instagram Forum
2 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
21 Jun 2016 à 11:49
21 Jun 2016 à 11:49
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
22 Jun 2016 à 08:09
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