Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 05-23-2012, 04:57 PM
grizz grizz is offline Using Conditional Formatting to identify duplicates Windows XP Using Conditional Formatting to identify duplicates Office 2003
Novice
 
Join Date: Jan 2012
Posts: 28
grizz is on a distinguished road
Default

highlight column A then conditional format / formula is
=ISNUMBER(MATCH(A1,B:B,0))
Reply With Quote
  #3  
Old 05-24-2012, 06:53 AM
namedujour
Guest
 
Posts: n/a
Default

Thank you so much! That works perfectly for Column A and Column B, but when I tried to edit the formula to expand the comparison range, it didn't work. I tried

=ISNUMBER(MATCH(A1,B:D,0))

I thought that the B:B portion of your original formula was the comparison range - that I would be comparing Column A to Columns B through D - but it didn't work. Is it necessary to create additional conditional formatting rules to compare other columns?

Thank you!
Reply With Quote
  #4  
Old 05-24-2012, 05:55 PM
grizz grizz is offline Using Conditional Formatting to identify duplicates Windows XP Using Conditional Formatting to identify duplicates Office 2003
Novice
 
Join Date: Jan 2012
Posts: 28
grizz is on a distinguished road
Default

try this --- highlight column A then formula is
=countif($B$1:$D$1000,A1)
and format your colour
Reply With Quote
Reply

Thread Tools
Display Modes


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 06:08 AM.


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