vaw30080 beware of case sensitivity. If your code contains = "Red" and you type red or RED in a cell your code will not work.

Using Select Case LCase(ActiveCell.Value) and then typing your code as "red" or "green" will change this.