PDA

View Full Version : Solved: compare a cell with another cell



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 nummber 2 in another cell in range("column A")

it this possible to solve with vba?



:help

Bob Phillips
12-03-2010, 11:04 AM
Use conditional formatting with a formula of

=G2=$A$2

and format the colour as required.