I want to match a number in a cell with 6 different columns. if the number
matches any cell in the columns I want the cell that it has matched to
highlight. Can this be done and if so how? Or am I on a hiding to nothing?

Thanks in advance