LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default Highlight or Mark any values in a column that are duplicates insidethe column

In particular, in my "Phone" column (B), I am wanting to be able tell
by looking at the value in the cell, that another cell in the column
has the same value (the same phone number). Conditional formatting I'm
guessing is the tool (I still want rows who's values aren't duplicates
to be visible, so I would prefer not using a filter) - but what would
the formula be - I am lost on this one.

Thanks in advance for you help!

magmike
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting formula to highlight items on column B inrelation to column A hombreazul Excel Discussion (Misc queries) 4 March 4th 12 02:43 PM
Filter duplicates based on criteria / column values phillr Excel Discussion (Misc queries) 0 April 9th 10 09:13 PM
Automatically highlight max and min values in a column in Excel Mahurshi Akilla Excel Discussion (Misc queries) 2 September 4th 07 05:19 AM
Coloring duplicates based on values in a column. Josh Excel Programming 6 June 4th 07 07:37 PM
How do I set up a column in Excel as a check mark column? wrsstevens Excel Discussion (Misc queries) 7 April 10th 07 07:12 PM


All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"