I had 2 tables like this table 1

and table 2

I want table 2 to be highlighted as if the value is correct.

Thanks in advance!

CodePudding user response：

Please try below CF rule-

=ISNUMBER(MATCH(1,($B$2:$B$5=$E3)*($A$2:$A$5=F$2)*($C$2:$C$5=F3),0))