Is there a way to have a two step conditional formatting in Google sheets?

Question

What I need to is a way to make a formula or use conditional formatting to achieve following.If cell A=1 and cell B>1 at the same time, then cell C turns red. Is it possible?

Tried using the "custom formula" feature in conditional formatting, but it does not allow to use more than value to use as a condition.

Thank you in advance.

Answer 1

You may try:

Apply to range: C:C

Custom formula is:

=(A1=1)*(B1>1)

Answer 2

The formating that usually works for me when doing conditional formating is =AND($A1=1,$B1>1)