Hi Guy's me again!
OK, I understand the conditoning of cells, but what I want to do is when I enter a number into a cell to have that number reflect a differnet colour
i.e
in cell A8, if I enter 1=red, 2=blue,3=orange, 4=yellow.... all the way to 10.
when ever I cahnge the number in that cell it reflects the colour I have assigned to it, my numbers are 1 through 10 so therefore I would have 10 differnet colours.
Now I have four clumns to which I need to enter a number from 1 to 10
i.e.
A8=3 (so that cell will turn orange)
B8=2 (so that cell will turn blue)
C8=4 (so then yellow)
Hope that is clear enough to understand
OK, I understand the conditoning of cells, but what I want to do is when I enter a number into a cell to have that number reflect a differnet colour
i.e
in cell A8, if I enter 1=red, 2=blue,3=orange, 4=yellow.... all the way to 10.
when ever I cahnge the number in that cell it reflects the colour I have assigned to it, my numbers are 1 through 10 so therefore I would have 10 differnet colours.
Now I have four clumns to which I need to enter a number from 1 to 10
i.e.
A8=3 (so that cell will turn orange)
B8=2 (so that cell will turn blue)
C8=4 (so then yellow)
Hope that is clear enough to understand