Guys, I am trying to validate a cell in Excel.

The user can only put in R (Red), A (Amber) or G (Green) in the cell. I want the RAG to be coloured accordingly.

Any idea how I can do this?

Many, many thanks.