How to check if two conditions are met in conditional formatting?

[billg127]

I have two conditional formatting rules. One highlights games that only appear once in a sheet, the other checks to see if the games exist in a list on another sheet, if so they turn yellow or green, respectively. The problem is some games satisfy both rules. I’d like to create a third rule which turns those games into a different color than the other two rules. Here are my two formulas, I just don’t know how to create the third rule. Anyone know how that would be done? Thanks!

=COUNTIF('Master Games List'!$F$2:$F$200,A3)>0
=COUNTIF($A$3:$M$2000,A3)=1

 

[Joe4]

Welcome to the Board!

Combine the two rules with the AND function, i.e.

=AND([COLOR=#333333]COUNTIF('Master Games List'!$F$2:$F$200,A3)>0,[/COLOR][COLOR=#333333]COUNTIF($A$3:$M$2000,A3)=1)[/COLOR]

 

[JoeMo]

Put the two together for the third rule:

=AND(COUNTIF('Master Games List'!$F$2:$F$200,A3)>0,COUNTIF($A$3:$M$2000,A3)=1)

Make this your first rule and check the box under Manage Rules that says "Stop if True".

 

[billg127]

Put the two together for the third rule:

=AND(COUNTIF('Master Games List'!$F$2:$F$200,A3)>0,COUNTIF($A$3:$M$2000,A3)=1)

Make this your first rule and check the box under Manage Rules that says "Stop if True".

Thank you, Gents!