select row DO and click Format-Conditional Formatting
select "Cell Value Is" and "equal to" and enter the following formula in the
box
=DQ1
Click Format and select an obvious background color like lime green
Click okay

every cell in DO that matches DQ will now be highlighted.

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