Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting formula to highlight items on column B inrelation to column A | Excel Discussion (Misc queries) | |||
Filter duplicates based on criteria / column values | Excel Discussion (Misc queries) | |||
Automatically highlight max and min values in a column in Excel | Excel Discussion (Misc queries) | |||
Coloring duplicates based on values in a column. | Excel Programming | |||
How do I set up a column in Excel as a check mark column? | Excel Discussion (Misc queries) |