Hello there,

I'm quite lost trying to figure out a simple solution to this. I have
simplified things to make things easier...

I have the following:

A B C D
1 (BLUE)
2 XY

The parantheses indicates the background color of the cell:

33 XX (RED)
34 XY (BLUE)
35 XZ (ORANGE)
36 XE (BLACK)

I need help in writing a program that will go through the range A2:D2
and try to match any non blank cells with the legend definitions in
rows 33:36, and make the background color of the cell above it equal
to the color that was looked up. In this example, I want the result of
the program to make cell B1 BLUE, which is the background definition
in row 33:36 for XY.

Please help me! You will make my day!