Using Excell 2003.
I have 7 cells in a row each with a different number in each cell.
Selecting the first cell I wish to compare the number against a column
consisting of 21 numbers.
If the number in the selected cell is the same as a number in the column I
want to select that cell background colour yellow.
If the number in the selected cell does not correspond with a number in the
column then move to the next cell on the row and repeat until all 7 cells on
the row have been checked.
Have tried various ways but am stuck.
Can anyone help?