View Single Post
 
Old 05-23-2012, 12:39 PM
namedujour
Guest
 
Posts: n/a
Default 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?
Reply With Quote