View Single Post
  #1   Report Post  
johnny
 
Posts: n/a
Default How can I compare a number against a list of numbers

In Excel 2003, I have a row of 7 numbers and wish to find if any of those
numbers is in a vertical list of 24 numbers and to highlight the numbers
which are on the vertical list.
Have tried writing a macro but have failed!