How do I change the cell colour per dropdown option?

I have a combo box created in Excel (just using Data => Validation => List)
and would like the cell colour to change automatically depending on what is
selected from the list. I.e. 'Completed' = Green etc.

Many Thanks!

Emma

Use Conditional Formatting
--
Gary''s Student


"Emma962" wrote:

> I have a combo box created in Excel (just using Data => Validation => List)
> and would like the cell colour to change automatically depending on what is
> selected from the list. I.e. 'Completed' = Green etc.
>
> Many Thanks!
>
> Emma