colour fill when selecting a value in list

Microsoft Microsoft excel 2007 full vers...
September 21, 2010 at 15:19:37
Specs: Windows 7
Hi All,

hope you can help! i have made a drop down list of 3 values in excel 2007, yes, no & N/A in 3 cells.
what i want to do is when i select yes in the drop down list it will have a green fill colour.
when i select No it will have a red fill colour, the N/A can be any colour.

Many Thanks

See More: colour fill when selecting a value in list

September 21, 2010 at 20:57:23
Are you familiar with the Conditional Formatting feature found on the Home ribbon?

Select the cells with your Drop Downs
Click on Conditional Formatting
Click on Highlight Cells Rules
Click on Equal to...
Enter Yes in the text field
Choose a Format from the drop down or chose Custom Format

Repeat for No

Repeat for N/A

Report •

September 22, 2010 at 12:08:50
Hi Derbydad03,

i have tried what you explained but the cells in the list change colour but not in the drop down box.

i have tried with the yes,no,n/a cells on the same sheet in the work book & on another sheet. i have also tried selecting Cond format,Highlight cells, containing text but only the cells in the list change colour!!

would be happy to upload work book if required??

Many Thanks Again

Report •

September 22, 2010 at 12:31:57
Let's say the Drop Down is in A1.

Let's say the list that populates that Drop Down is in B1:B3

Are you saying that if you select A1 and perform the Conditional Formatting steps on it, a cell in B1:B3 changes color?

Even from this far away, I'd be willing to bet that that isn't happening.

Report •

Related Solutions

September 22, 2010 at 13:22:42
Hi Again,

what i was not doing after cond formating, etc,etc the three values, was then selecting the drop down cell & re-doing all over again!!

did not know i had to do the process twice per cell value!

all sorted now Thanks.

Report •

September 22, 2010 at 13:49:03
re: "did not know i had to do the process twice per cell value!"

You don't.

There's no reason to Conditionally Format the list you are using to populate the Drop Downs with, unless you are doing it just for show. Heck, you could do that just with fill colors - no need to CF them.

The only cells you need to CF are the ones with the Drop Downs and you can do them all at once as long as they will contain the same values and be set to the same colors.

Select all of the Drop Downs at once and follow the CF procedure. The CF will be applied to each cell individually.

In fact, if you select all of the Drop Downs and the list, you could CF everything all at once. But again - the source list for the Drop Downs does not need to be CF'd for the CF of the Drop Downs to work.

Report •

Ask Question