automatically change cell colours

[John Davies]

I know that there are 3 conditional formats that you can use to change cell
colours but is there a way to link a cell input to more than 3 colours.

 

[DNA]

Not sure if this will help, but give it a try:

http://cpearson.com/excel/colors.htm

HTH