Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup and match color of corresponding cell
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color Match Adjacent Cell | Excel Discussion (Misc queries) | |||
word match in string text in cell, color format cell | Excel Discussion (Misc queries) | |||
Make text color match cell color with macro? | Excel Discussion (Misc queries) | |||
Font Color to match other cell | Excel Programming | |||
Match TextBox Back Color to Cell Fill Color | Excel Programming |