Matching two cells in the same column

[Dena]

Is there a formula that can be used if two cells in the same column match to apply formatting?

[shg]

See http://www.youtube.com/watch?v=-jz-EWzmzPk

[Dena]

What I would like to happen is a formula to look matching cells in column G. If they match then to highlight the two rows that the matching data is in. Is this possible?

[shg]

That's what the conditional formatting does, minus the need for a formula ...

But if you're bent on a formula, in H2 and copy down, =countif(g:g, g1) > 1 and use that result with conditional formatting.

[Dena]

thank you, when I used the duplicate value conditional formatting it didn't focus on one column, it highlight every cell that had a duplicate somewhere on the spreadsheet.

[shg]

You're welcome.

it highlight every cell that had a duplicate somewhere on the spreadsheet

You need to select the data of interest before applying the formatting.