Conditional Format

Dez

Board Regular
Joined
Apr 23, 2004
Messages
63
Hi,
I have a cell with a drop down menu with a list of 15 names, when I select a name from the list I would like the cell's background colour to change from white to yellow, but remain white while the cell is empty. If I use conditional formaing it allows only one name in the criteria and I have about 15, is there a formula the I can use to fix this???

Cheers

...Dez...
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
You sure that doesn't work? Make sure you select "Formula Is" in the conditional formatting box.

The formula should be =LEN(CELL REF)>0 where CELL REF is equal to the cell where your drop down lists is.

Just a thought... did you create your drop down list using Data Validation or using the VBA controls?
 
Upvote 0
But when I delete the cell contents the colour remains? I need it to go back to no-fill

Cheers

...Dez...
 
Upvote 0
Still not able to get rid of the colour in the cell when the data is deleted i.e. when I select a name from the drop down box it enters it and changes the colour of the cell, when I delete the name from the cell the background colour remains which I need to go back to white or no-fill???

Cheers ...Dez...
 
Upvote 0
PM me your email address and I'll send you the work book I tested this on.

You can then look@ the setup of the conditional formatting and apply it to your workbook.
 
Upvote 0

Forum statistics

Threads
1,224,416
Messages
6,178,504
Members
452,853
Latest member
philipnjk64

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top