| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
duplicate text
How do you find duplicate text entries using conditional formatting? All
information is geared towards number format. I have names (all in one col) that I would like to find out if they are duplicated... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
duplicate text
Highlight the range you wish to Format. then do Format ConditionalFormat
CellValueIS EqualTo =$B$1 Format select the formatting ok ok Then, whatever value you type in cell B1, all cells in your range that match that value will be Conditionally formatted......... hth Vaya con Dios, Chuck, CABGx3 "JN" wrote: How do you find duplicate text entries using conditional formatting? All information is geared towards number format. I have names (all in one col) that I would like to find out if they are duplicated... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
duplicate text
See Chip Pearson's site for highlighting duplicates using CF.
http://www.cpearson.com/excel/duplic...tingDuplicates Gord Dibben MS Excel MVP On Thu, 28 Sep 2006 08:52:01 -0700, JN wrote: How do you find duplicate text entries using conditional formatting? All information is geared towards number format. I have names (all in one col) that I would like to find out if they are duplicated... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
duplicate text
Thank you so much! I forgot the = sign!
"CLR" wrote: Highlight the range you wish to Format. then do Format ConditionalFormat CellValueIS EqualTo =$B$1 Format select the formatting ok ok Then, whatever value you type in cell B1, all cells in your range that match that value will be Conditionally formatted......... hth Vaya con Dios, Chuck, CABGx3 "JN" wrote: How do you find duplicate text entries using conditional formatting? All information is geared towards number format. I have names (all in one col) that I would like to find out if they are duplicated... |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
duplicate text
Happy to help.......thanks for the feedback.
Vaya con Dios, Chuck, CABGx3 "JN" wrote: Thank you so much! I forgot the = sign! "CLR" wrote: Highlight the range you wish to Format. then do Format ConditionalFormat CellValueIS EqualTo =$B$1 Format select the formatting ok ok Then, whatever value you type in cell B1, all cells in your range that match that value will be Conditionally formatted......... hth Vaya con Dios, Chuck, CABGx3 "JN" wrote: How do you find duplicate text entries using conditional formatting? All information is geared towards number format. I have names (all in one col) that I would like to find out if they are duplicated... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| moving text from a word document to excel | New Users to Excel | |||
| Finding the most common cell duplicate (text) | Excel Discussion (Misc queries) | |||
| Finding Duplicate text strings with a single column | Excel Worksheet Functions | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
Linear Mode
