Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |