Painting a cell depending on written content

[ruthbelilty]

Hi experts

I would like to paint cell depending it's content.
The content is chose from a list.

For example:
A cell had a list of values: Value 1 and Value 2
when the cell is empty (no value has been chosen) it's color shoul
remain white.
When we pick value 1 in list, the cell becomes red.
When we pick value 2 in list, the cell becomes Blue.

Thanks for your help

Rut

 

[Debra Dalgleish]

You can use conditional formatting to colour the cells. There are
instructions in Excel's Help, and here:

http://www.contextures.com/xlCondFormat01.html