- Registration date
- Sunday September 12, 2010
- Last seen
- November 5, 2020
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.