If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|