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

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" <(E-Mail Removed)> wrote in message
news:7467CDF0-0A88-4377-A158-(E-Mail Removed)...
> 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

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

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

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" <(E-Mail Removed)> wrote in message
> news:7467CDF0-0A88-4377-A158-(E-Mail Removed)...
> > 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
>
>