Conditional formatting based on two cells (date and comment)
Solved/Closed
Related:
- Conditional formatting based on two cells (date and comment)
- Comments on this post have been limited - Instagram Forum
- Based on the values in cells b77 ✓ - Excel Forum
- Your comment goes against community standards - Facebook Forum
- Excel date format dd.mm.yyyy - Guide
- Return Seq Values Until Blank value then return different set of seq values ✓ - Excel 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