here's one I'm sure has been asked many times before...

Column A, contains an option of HIGH, Medium, Low.
Based on what is entered, colour the cell automatically, Red, Yellow, Green.

Anyone got the formula? Or do I need to put some code in? I don't know how
to put code in, so if this is answer, please give brief guide too! Thanks...