Hi!

I am back with yet another question. I have two sheets in my excel file. The first contains a ToC (Column A). After each heading, I list 1-9 numbers each in a column by itself.

Sheet One
1 Introduction 34 31 425 213 54
1.2 NNNNNN 23 32 51 21 214 341
.
.
.

Sheet two
Here all the numbers above are listed in different rows, but with UR added to them:
Column A
UR23
UR32
UR31
UR34
.
.
.
In Column F (on the same line as the UR# in A), I have listed a value 1, 2, 3 or 4.

QUESTION:
I want to write a macro that will look in Column B/Sheet 1, and see what number in Sheet 2, Column F (1, 2, 3 or 4) corresponds to that number. Then I want to change the color of the particular cell in sheet one. Say 1=green, 2=yellow, 3 = orange and 4 = red.

As there may be several values in sheet one, as shown above, I want to look at the next number in the C column and to the same with that number and then continue until there are no more numbers in that column. Then I want to go to the next row and do the same.

Is there an "easy" way to do this w/o having to read litterature for the next week? If so, any help would be greatly appreciated.