Using traffic light drop down without changing text / value in cell

[blunp1807]

Hiya,

I would like to create a traffic light (Red amber green) so that i can monitor for whether things are on track for a deadline for major projects. ie. I wish to be able to select a drop down that says 'Late' under for example 01/11/2013, but all i want is for the box to turn red. and the date stay there. I would like to do this for all 3 colours. Sounds odd and that maybe changing the colour backgrounds would be easier. but its not no big projects. If anyone can help i will be ridiculously happy!

Pete

 

[Justin Mead]

You might want to look into conditional formatting. You can have cells automatically highlighted to a specific color given certain criteria.