Formula
 

I have a spreadsheet that has a name in cell a1 and in cell a2 I have a
number 1,2, or 0 depending on the person. Im trying to figure out a way for
the persons name to change colors depending on the value in cell a2.
Exampler: 0=black
1=blue
2= red
They all start at 0 and if the lose 1 game then i will change it to 1 and if
they lose another then I will change it to 2 and then they are out but I cant
figure out how to get excel to do this automaticly when I chane the value of
a2.
Thanks
Larry

Formula
 

Click in A1, then:

<Format <Conditional Formatting,
Change "Cell Value Is" to "Formula Is",

And enter this formula:
=A2=1

Then click on <Format,
And choose a nice Blue color, then <OK

Then click on "Add", for the second condition,

Again, change "Cell Value Is" to "Formula Is",

And enter this formula:
=A2=2

Then click on <Format,
And choose a nice Red color, then <OK <OK

And you're done.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Larry" wrote in message
...
I have a spreadsheet that has a name in cell a1 and in cell a2 I have a
number 1,2, or 0 depending on the person. Im trying to figure out a way
for
the persons name to change colors depending on the value in cell a2.
Exampler: 0=black
1=blue
2= red
They all start at 0 and if the lose 1 game then i will change it to 1 and
if
they lose another then I will change it to 2 and then they are out but I
cant
figure out how to get excel to do this automaticly when I chane the value
of
a2.
Thanks
Larry

Formula
 

Hey RAGDYER
Thanks but it didnt work
Column A Column B
Bryan 0
Dave 1
Greg 1
Mike 2

I want column A to change the colors everytime I change the value in column
B. Example if I decided to change Bryan's 0 to a 1 I want his color to
change to blue. and I f I change Greg's 1 to a 2 his cell would change to red.
Thanks
"Ragdyer" wrote:

Click in A1, then:

<Format <Conditional Formatting,
Change "Cell Value Is" to "Formula Is",

And enter this formula:
=A2=1

Then click on <Format,
And choose a nice Blue color, then <OK

Then click on "Add", for the second condition,

Again, change "Cell Value Is" to "Formula Is",

And enter this formula:
=A2=2

Then click on <Format,
And choose a nice Red color, then <OK <OK

And you're done.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Larry" wrote in message
...
I have a spreadsheet that has a name in cell a1 and in cell a2 I have a
number 1,2, or 0 depending on the person. Im trying to figure out a way
for
the persons name to change colors depending on the value in cell a2.
Exampler: 0=black
1=blue
2= red
They all start at 0 and if the lose 1 game then i will change it to 1 and
if
they lose another then I will change it to 2 and then they are out but I
cant
figure out how to get excel to do this automaticly when I chane the value
of
a2.
Thanks
Larry

Formula
 

What didn't work?

You *originally* said name in A1,
And number in A2.

How does that match up to what you're asking *now*?
Name in Column A,
And number in Column B.

Follow the same instructions I originally gave, but change the formulas to:

=B1=1
And
=B1=2

Then, after you choose your colors and <OK out,
Click in A1,
Click on the "Format Painter" icon (yellow paint brush),
Click in A2 and drag down as needed, to duplicate the format to the
pertinent cells in Column A.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"lwa1974 Larry" <lwa1974 wrote in message
...
Hey RAGDYER
Thanks but it didnt work
Column A Column B
Bryan 0
Dave 1
Greg 1
Mike 2

I want column A to change the colors everytime I change the value in
column
B. Example if I decided to change Bryan's 0 to a 1 I want his color to
change to blue. and I f I change Greg's 1 to a 2 his cell would change to
red.
Thanks
"Ragdyer" wrote:

Click in A1, then:

<Format <Conditional Formatting,
Change "Cell Value Is" to "Formula Is",

And enter this formula:
=A2=1

Then click on <Format,
And choose a nice Blue color, then <OK

Then click on "Add", for the second condition,

Again, change "Cell Value Is" to "Formula Is",

And enter this formula:
=A2=2

Then click on <Format,
And choose a nice Red color, then <OK <OK

And you're done.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Larry" wrote in message
...
I have a spreadsheet that has a name in cell a1 and in cell a2 I have a
number 1,2, or 0 depending on the person. Im trying to figure out a way
for
the persons name to change colors depending on the value in cell a2.
Exampler: 0=black
1=blue
2= red
They all start at 0 and if the lose 1 game then i will change it to 1
and
if
they lose another then I will change it to 2 and then they are out but
I
cant
figure out how to get excel to do this automaticly when I chane the
value
of
a2.

Thanks
Larry