Conditional formatting based on two cells (date and comment)
Solved/Closed
Related:
- Conditional formatting based on two cells (date and comment)
- Excel date format dd.mm.yyyy - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Your comment goes against community standards - Facebook Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Aug 4, 2016 at 11:41 AM
Aug 4, 2016 at 11:41 AM
Hi Lucie,
Combine the 2 formulas using AND:
=AND(first formula , second formula)
For your second question, choose to manage your rules. The 3rd column of the overview shows the applied range.
Let me know if something is still unclear.
Best regards,
Trowa
Combine the 2 formulas using AND:
=AND(first formula , second formula)
For your second question, choose to manage your rules. The 3rd column of the overview shows the applied range.
Let me know if something is still unclear.
Best regards,
Trowa
Aug 4, 2016 at 12:20 PM