functions for drop down menu...

  • Thread starter Thread starter Altan
  • Start date Start date
A

Altan

I need to set up a drop down menu that has the following:
En or Dis. I would like the background color of En to
turn blue when you select it; when selecting Dis its
background should turn to Red, additionally only when
selecting Dis, I want the text typed to the left of the
drop down menu to be completly removed.

Thanks,
Laint
..
 
Hi Atlan
1. Go to 'Data - Validation' and insert the allowed values as list
2. Use conditional format ('Format - Conditional format') to set the
background accordingly

For the text removing:
- you can set the text colour to white (also as conditional format).
Easy solution
- if you realy want to delete the text you have to youse VBA (IMHO) and
evaluate the worksheet_change event
Frank
 
Back
Top