I am wanting to create a drop down list so i can change the colours of the background of the cells only, not change the information that is in the cell. The reason for this is, i have a column with $$ values in them and we change the background colour of the cells( up to 6 colours) so we can determine what stage a project is at by the colour background. I understand how to make a drop down list using Data etc but this has beaten me. Any help would be appreciated.