#1
|
|||
|
|||
Change cell color everytime a value is selected in dropdown list
I am trying to create a data entry form and I have created a dropdown list based on the actions the users can choose from. Like for example, if the user chose Remove Access, some cells will be grayed out and if workable, cannot be filled out; same goes to other value when they select, there will be specific fields that cannot be filled out. Is it possible without having complicated macro programming?
Thanks so much for the help! |
#2
|
|||
|
|||
see if this file is in the idea your looking for
|
#3
|
|||
|
|||
hi grizz! yes, this is the idea. how did you do that? sorry, im logging now at my notebook with Excel starter 2010...I have attached the form that i'm working on...my idea is that once the Remove access is selected, the Start Date will be grayed out...then when Create New User is selected and the status is Permanent, End Date will be automatically set as 30/12/2099, but if the status is Contractor, the End Date can be filled up. am i asking too much?
thanks so much! |
#4
|
|||
|
|||
can you tell me what cells you want to be grayed out and unuseable with what option in drop down
|
#5
|
|||
|
|||
take a look at your file and see what else needs to be added
|
Tags |
change color, data validation |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dropdown list of email addresses | J Partridge | Outlook | 1 | 01-13-2011 06:37 AM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
How can I make a cell color RED under the Today's date cell? | Learner7 | Excel | 2 | 07-08-2010 12:52 AM |
Filtering on cell color | mattc | Excel | 1 | 04-30-2010 09:27 AM |
Extracting Cell color | bsaucer | Excel | 1 | 06-19-2009 06:52 AM |