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 Contributor Last seen December 27, 2022 - Dec 19, 2013 at 11:06 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Dec 19, 2013 at 11:06 AM
Related:
- Conditional formatting to colour cell based on text in another
- Excel conditional formatting based on date - Guide
- Rj45 colour code - Guide
- Based on the cell values in cells b77 - Excel Forum
- Based on the values in cells b77 b88 - Excel Forum
- How to clear formatting in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
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