Sheet 1 contains a (2 digit) integer in each of cols A to F.

There are no duplicates. There are no integers greater than 50.

I would like to shade the background of the cell in sheet 2 where the
integers in sheet 1 are the column numbers.



So, for example, if Sheet1.Range("A1") = 27 then

Sheet 2.Range("A27").interior.color = black.



The row numbers would be the same on both sheets.



I hope this makes sense.