Using Conditional Formatting to identify duplicates
How do I use Conditional Formatting to only react to an EXACT MATCH? I tested it on two columns. Column A had numbers 12 to 45. Column B had numbers 120, 121 and 122 - and then I stopped because it forrmatted them all as a "match" because of the "12" and the "21" and the "22" in column A.
Is this beyond the scope of Conditional Formatting? Do I need to try a MATCH function instead?
|