Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Conditional Formatting to identify duplicates Conditional Formatting. Laurie B. Excel 6 04-09-2012 05:01 PM
Conditional formatting zanat0s Excel 4 01-20-2012 03:30 AM
Using Conditional Formatting to identify duplicates Conditional formatting with AND, OR Lucky Excel 2 10-03-2011 11:41 PM
Using Conditional Formatting to identify duplicates Conditional Formatting namedujour Excel 3 08-25-2011 01:46 PM
Using Conditional Formatting to identify duplicates help with conditional formatting Snvlsfoal Excel 3 07-03-2011 11:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft