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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell color
Hi Mir Khan
Maybe something like this site would help. http://www.xldynamic.com/source/xld.....Download.html which will give you up to 30 CF conditions per cell. Regards Cimjet "Mir Khan" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell color
What version of Excel are you using? If 2007, you probably could do this
with conditional formatting. If 2003, you only have 3 conditions (+ a 4th default) to work with for conditional formatting. I don't have 2007 yet, so can't check that. -- 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell color
Thanks Barb and Cimjet for the solutions. Cimjet I have tried CF from
http://www.xldynamic.com/source/xld.....Download.html it worked but now my excel spreadsheet is extremely slow and it can't be used. is there a way that we can solve this performance issue or is there any other way of doing it. Canit be done using a macro VBA code? Please help me. Thanks Mir Khan "Cimjet" wrote: Hi Mir Khan Maybe something like this site would help. http://www.xldynamic.com/source/xld.....Download.html which will give you up to 30 CF conditions per cell. Regards Cimjet "Mir Khan" wrote in message ... 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 |
Reply |
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 |