same data colums

[Guest]

Hello,

If I have 2 data colums how can I highlight the words in each colum that are
the same?
Example:

cat horse
dog frog
horse dog

.....It should highlight the words dog and horse in each colum.

Thank You!

 

[JulieD]

Hi

this idea comes from
http://www.cpearson.com/excel/duplicat.htm
under the heading "Highlighting Duplicate Entries"

select your two columns of data, click in the name box (little box to left
of formula bar) and type
range1
and press ENTER
now with the columns still selected choose format / conditional formatting
choose formula is
type
=IF(COUNTIF(range1, A1)>1,TRUE,FALSE)
where A1 is the first cell in your two columns of data
click on the format button
set a format, click OK twice.