how to compare 2 sheets and mark the duplicate values?

Try conditional formatting with a formula of

=COUNTIF([z.xlsx]Φύλλο1!$A$1:$D$6,B1)>0
 
i tried but nothing! doesn't mark the values.

i tried this =match("Φύλλο1!$A$1:$D$6";B1)>0
and give me that:View attachment z3.xlsx
 
Last edited:
Back
Top