View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
greenchk greenchk is offline
external usenet poster
 
Posts: 1
Default Conditional Formatting

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.