Hi,

i have 2 sheets
in sheet1 there is a row with numbers in one column
in sheet2 there are the same numbers, but in random positions across the sheet

what i want to do: if i change the background color of any number on sheet1 , it should also change the color of the same number in sheet2.

After trying to find out how this could be made possible, i found out the only way this could be done is by vba.
But since i have 0 experience in vba, I would appreciate it, if someone could help me out here.