Select a cell then DataValidationAllowList.

In source enter low,medium,high OK your way out

FormatConditional FormattingCondition1Cell Value is: equal to low Format to
green pattern.

Add two more conditions for medium and high with your choice of colors.

OK your way out.


Gord Dibben MS Excel MVP

On Tue, 15 Jan 2008 13:46:03 -0800, Jay wrote:

I would like to setup a drop down list that when the user selects a value it
will turn the cell a meaningful corresponding color...like red for high
severity...etc.