Conditional Formatting using And and Or

[Misfitroxy]

Hello all,

I have a checklist I am creating and I need to have cells format based on two (kind of 3) criteria.

It will go by state and then county.

So if F6="z" state AND F8 equals either "x" OR "y" counties

Can someone help with this formula please?

 

[Special-K99]

Select cell

Conditional Formatting
New Rule
Use a formula to determine...

=AND(F6="z",OR(F8="x",F8="y"))

format as required
Use Format painter (paintbrush icon) to copy to other cells

 

[Misfitroxy]

Thank you, I was putting the () in the wrong places