K
K1KKKA
Help.
I would like to know if it is possible to have a macro that changes
the colour of a cell dependant on the number or text within.
eg
If the following cells were populated as follows
a1=1 Make the cell Green
=2 Make the cell Red
=3 Make the cell Blue
=4 Make the cell Orange and so on till 7
Is this at all possible ?
I know that i can colour cells 3 times with simple conditional
formatting, but would like to run upto seven different colours.
any help would be appreciated.
Steve
I would like to know if it is possible to have a macro that changes
the colour of a cell dependant on the number or text within.
eg
If the following cells were populated as follows
a1=1 Make the cell Green
=2 Make the cell Red
=3 Make the cell Blue
=4 Make the cell Orange and so on till 7
Is this at all possible ?
I know that i can colour cells 3 times with simple conditional
formatting, but would like to run upto seven different colours.
any help would be appreciated.
Steve