Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create Dropdown lists not using Data Validation
Does anyone have any suggestions on creating dropdown lists other than using
Data Validation. I'm creating a checklist in Excel and I want to control what users enter and also do some conditional formatting (i.e. select completed, the cell goes green, overdue, the cell turns red). I expect to have about 20 items to track and for each one the options will be different. The reason I don't want to use Data Validation is that I want to publish this to Sharepoint and Sharepoint Excel web part services do not support Data Validation. Would appreciate any suggestions. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble With Data Validation And Filtering On A Dropdown | Excel Worksheet Functions | |||
Show do I share a dynamic list for data validation? | Excel Discussion (Misc queries) | |||
How to create identical dropdown lists in large blocks of cells | Excel Discussion (Misc queries) | |||
data validation lists | Excel Discussion (Misc queries) | |||
how do I add data validation dropdown lists to a Form | Excel Worksheet Functions |