Conditional formatting to colour cell based on text in another
Closed
nicm123
Posts
1
Registration date
Monday December 16, 2013
Status
Member
Last seen
December 16, 2013
-
Dec 16, 2013 at 06:25 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 19, 2013 at 11:06 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 19, 2013 at 11:06 AM
Related:
- Conditional formatting to colour cell based on text in another
- Crimping colour code - Guide
- Clear only the formatting from the selected cell (leaving the content) - Guide
- If a cell has text then return value ✓ - Excel Forum
- Instagram account based in wrong country - Instagram Forum
- Excel macro to create new sheet based on value in cells - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 19, 2013 at 11:06 AM
Dec 19, 2013 at 11:06 AM
Hi Nicm,
You could use AND:
=AND($C8<=TODAY()-14,$J8<>"Approved",$J8<>"Rejected")
Best regards,
Trowa
You could use AND:
=AND($C8<=TODAY()-14,$J8<>"Approved",$J8<>"Rejected")
Best regards,
Trowa