Drop Down Menus

ginauk84

New Member
Joined
Aug 1, 2005
Messages
32
I am using data validation to create some drop down menus. The same drop down menus are used in loads of different workbooks. I believe there is a way you can link to a master workbook so that every time I update the drop down I don't have to go in and out of every workbook, I can just change the master and all the other workbooks will follow.

Also there is an option in the drop down 'other' and we need people to fill in the cell to the right to say what 'other' is. People aren't doing this so we wondered if there was any way for the cell on the right of the drop down to flash or something when this option was selected?
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
50,644
Office Version
  1. 365
Platform
  1. Windows
Also there is an option in the drop down 'other' and we need people to fill in the cell to the right to say what 'other' is. People aren't doing this so we wondered if there was any way for the cell on the right of the drop down to flash or something when this option was selected?
For this part use Conditional Formatting. If your drop-down is in cell A1, then:
1. Select B1
2. Format|Conditional Formatting...|Condition 1|Formula is: =A1="Other"|Format|Patterns|choose your colour|OK|OK
 

Forum statistics

Threads
1,141,591
Messages
5,707,277
Members
421,499
Latest member
Dpbj

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
Top