Colouring cells

[Guest]

How can I colour a cell with a different colour depending on the value selected from a drop down box?

 

[sax]

Hi,
You can use Conditional Formatting.
"Format"-"Conditional Formmating"
Put Cell value to be the one from drop down list, and in Format go to patterns and select colour.
The bad thing is that you can have only three conditions, meaning that you can have only three different numbers from drop down list.
Myybe someone can help you with some VBA formula.
Sax