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 another cell text ✓ - Forum - Excel
- Conditional formatting based on another cell date - Guide
- Conditional formatting based on another cell; apply to rows ✓ - Forum - Excel
- Conditional Formatting based on two cell values ✓ - Forum - Excel
- Conditional formatting based on another cell ✓ - Forum - Excel
1 reply
TrowaD
Aug 4, 2016 at 11:41 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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