Hello all,
I currently know how to do a conditional format on values to find duplicates using conditional formatting and the following formula:
=COUNTIF($U$2:U2,U2)>1
However, I now want to check Column U for duplicates of the values in Column V.
For example, if the number 54555586 occurs in column V AND in Column U, I want that particular value in Column U to be highlighted.
Please help!
I currently know how to do a conditional format on values to find duplicates using conditional formatting and the following formula:
=COUNTIF($U$2:U2,U2)>1
However, I now want to check Column U for duplicates of the values in Column V.
For example, if the number 54555586 occurs in column V AND in Column U, I want that particular value in Column U to be highlighted.
Please help!