Formula

L

Larry

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
 
R

Ragdyer

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.
 
L

lwa1974 Larry

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
 
R

RagDyer

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.
 
Top