How do I create a drop down cell menu with different colour cells

G

Guest

I want to create a drop down menu in a cell where the only answers are Red,
Amber or Green, but I want the cell to background fill with the colour!

Thanks in advance!!

Alistair
 
G

Guest

How about going to Data - Validation, then List, input Red, Amber, Green, and
then in that Cell, do a Conditional Format with those three Conditions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for Dates and CF Colour then convert to Text 3
Multiple Conditionals in MS Excel 2007 6
Formatting a cell with colour based on whether another cell's valu 1
Conditional Formatting Traffic Light System 3
Conditional formatting 3
cell vlue based on cell back colour 6
Conditional formatting based on adjacent cell? 1
Target cell coloured based on whether one cell has a greater value 2

Top