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 conditional formatting if another cell contains specific text ✓ - Excel Forum
- How to change account based in instagram - Instagram Forum
- Your comment goes against community standards - Facebook 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
552
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