Cell color
I'll tell you what I'm thinking you can do.
Define a workbook level named range for the range in Sheet 2 that you'd use
for a VLOOKUP to get the value from Column C.
In your conditional format (hopefully you have 2007), you can put in
=VLOOKUP(A1,RangeName,3,false) = "A" or "B" or "C" or "D" or "E"
You can set your conditional format for each of those conditions.
--
HTH,
Barb Reinhardt
"Mir Khan" wrote:
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
|