If both counts are positive (i.e.
non-zero), the AND function will return TRUE and trigger the conditional format.
AND returns TRUEonly if all the conditions are met.
If any conditions are not met, the AND function returns FALSE.
Find duplicate values in two columns
To highlight duplicate values in two or more columns, you can use conditional formatting with on a formula based on the COUNTIF and AND functions. In the example shown, the formula used to highlight duplicate values is: =AND(COUNTIF(range1,B5),COUNTIF(range2,B5)) Both ranges were selected at the same when the rule was created.
