Conditional formatting based on two cells (date and comment)
Solved/Closed
Related:
- Conditional formatting based on two cells (date and comment)
- Excel conditional formatting based on date - Guide
- Comments on this post have been limited - Instagram Forum
- Based on the values in cells b77 b88 - Excel Forum
- Clear cell contents based on value of another cell range using VBA ✓ - Excel Forum
- Your comment goes against community standards - Facebook Forum
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