u25103
12-03-2010, 03:05 AM
Hi here is my problem.
In range (column A) A2 to A48 I write in random values between 1 to 100
In a another range ("column G") the numbers 1 to 100 sorted.
Now if I write number 2 in range A2 i want the number 2 in column G highlighted in a specific colorindex.
And if number 2 is already in column A how do prevent myself to write number 2 in another cell in range("column A")
it this possible to solve with vba?
:help
In range (column A) A2 to A48 I write in random values between 1 to 100
In a another range ("column G") the numbers 1 to 100 sorted.
Now if I write number 2 in range A2 i want the number 2 in column G highlighted in a specific colorindex.
And if number 2 is already in column A how do prevent myself to write number 2 in another cell in range("column A")
it this possible to solve with vba?
:help