I have data in three columns. I want the rows to highlight if the data in one
row matched all three columns of another row:

For example:

1 21N 16W no highlight
1 21N 18W no highlight
1 22N 15W highlight
1 22N 15W highlight
1 22N 15W highlight

Thank you for your help.

Selecting a cell in row 1

Format-Conditional Format
formula is:
=SUMPRODUCT(--($A$1:$A$100=$A1),--($B$1:$B$100=$B1),--($C$1:$C$100=$C1))1

Adjust range sizes as necessary. Note that you can't callout entire column
in SUMPRODUCT unless using XL 2007.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"greenchk" wrote:

I have data in three columns. I want the rows to highlight if the data in one
row matched all three columns of another row:

For example:

1 21N 16W no highlight
1 21N 18W no highlight
1 22N 15W highlight
1 22N 15W highlight
1 22N 15W highlight

Thank you for your help.