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