Conditional Format

[Dez]

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...

 

[PA HS Teacher]

Format, Conditional Formating, Formula is
=LEN(A1)

or
=Len(A1)>0

 

[Dez]

That doesn't seem to work??

Cheers

...Dez...

 

[Banker1]

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?

 

[Dez]

But when I delete the cell contents the colour remains? I need it to go back to no-fill

Cheers

...Dez...

 

[Banker1]

Works for me... I can send you my example if you'd like... PM me your email addy.

 

[Dez]

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...

 

[Banker1]

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.

 

[Dez]

Hi Banker1,

I've PM 'ed my email to you a few times? Anyway my email for this forum is dezdecker@hotmail.com

Cheers ...Dez...

 

[Banker1]

Hi Banker1,

I've PM 'ed my email to you a few times? Anyway my email for this forum is dezdecker@hotmail.com

Cheers ...Dez...

I only recently recieved your PM (received 1 only as well). Anyway, check your email, if you have any questions let me know.