View Single Post
 
Old 01-25-2012, 12:23 PM
angelica_gloria angelica_gloria is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Jan 2012
Posts: 2
angelica_gloria is on a distinguished road
Exclamation 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!
Reply With Quote