How do I change the cell colour per dropdown option?

E

Emma962

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
 
Top