Normal highlighting based on values entered can be done using conditional formatting.
Dec 17 2013 02:42 PM
But since you want your color to change based on clicking a cell - this can be done using macros. You can record a macro that contains the exact steps that you described in your question. the