Hi all,


I've got a spreadsheet where I want to create a drop down box to change the colour of a cell but not alter the text that is in it.

I know you can make a drop down list for example "complete, incomplete" then you can use conditional formatting to have complete be green in colour and incomplete be red. This however isn't exactly what I want as I don't want text to overwrite what is in the cell.


thanks