Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell color
Hi Experts, please help me with this question.
I have 2 sheets. In sheet 2 column A has Names and column C has letter A, B, C, D or E. Sheet 1 has names placed randomly in first 300 rows and are linked to Column A from Sheet 2 any change made in column A in sheet 2 is reflected in sheet 1]. The cells (in sheet 1) with names should get a color based on column C in sheet 2. In sheet 2 if C1 is 'A' then the cell (in sheet1 ) which is linked to A1 in sheet 2 should get light yellow color. OR.. In sheet 2 if C1 is 'B' then the cell (in sheet1 ) which is linked to A1 in sheet 2 should get light green color. OR... In sheet 2 if C1 is 'C' then the cell (in sheet1 ) which is linked to A1 in sheet 2 should get light blue color. OR... In sheet 2 if C1 is 'D' then the cell (in sheet1 ) which is linked to A1 in sheet 2 should get light pink color. OR... In sheet 2 if C1 is 'E' then the cell (in sheet1 ) which is linked to A1 in sheet 2 should get light brown color. This is the third time i am trying to explain what i need, but i think for some reason i am not able to convey what i need. I have tried again one more time. i can call at any number if you can provide to explain my question. Thanks Mir Khan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
change fill color of a range of cells based on color of a cell? | Excel Programming | |||
Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
Browse Forms Controls and change TextBox color based on cell color | Excel Programming |