Thread: Compare Text
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Steph Steph is offline
external usenet poster
 
Posts: 110
Default Compare Text

One more option for you. In Excel 2007, you can select both columns, go to
Conditional Formatting, Highlight Cells Rules, and choose Duplicate Values.
It will fill cells with duplicate values with color.

"Toria" wrote:

Hello,

I have two columns of names, DO and DQ. I need to know when there's a match
without going row by row and maunally eyeballing it. I've spent all morning
trying to figure out. Any help is much appreciated.

Thank you.