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...

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...

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...

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...

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...