If a cell has a certain value after certain date, color the row
Solved/Closed
Related:
- Highlight row if cell contains date
- Conditional formatting highlight row if cell contains date - Best answers
- Excel conditional formatting highlight row if cell contains text - Best answers
- Vba highlight row if cell contains ✓ - Forum - Excel
- Highlight row if cell contains specific text ✓ - Forum - Excel
- Excel - Macro to highlight Rows with Duplicate values in a cell ✓ - Forum - Excel
- Excel vba copy row if cell value matches ✓ - Forum - Office Software
- Copy row if cell contains ✓ - Forum - Excel
2 replies
TrowaD
Jun 21, 2016 at 11:49 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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
TrowaD
Jun 27, 2016 at 09:30 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Jun 27, 2016 at 09:30 AM
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