Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel data validation
Greetings all. First poster here. I'm working on making some changes to a rather elaborate Excel spreadsheet that was developed by a predecessor. One of the changes I have been asked to make involves a cell where input is restricted by values contained in a list. I was asked if the cell's value can be set by a conditional statement while still retaining the cell validation. The value to be selected based on the condition is in the list used for data validation. I've tried inputting the conditional statement but get an error stating that "The value you entered is not valid". Any advice would be appreciated. -- craig-o ------------------------------------------------------------------------ craig-o's Profile: http://www.excelforum.com/member.php...o&userid=27588 View this thread: http://www.excelforum.com/showthread...hreadid=471110 |
#2
|
|||
|
|||
Hi Craig
Take a look at Debra Dalgleish's site for well explained details about all forms of data validation. http://www.contextures.com/xlDataVal02.html Regards Roger Govier craig-o wrote: Greetings all. First poster here. I'm working on making some changes to a rather elaborate Excel spreadsheet that was developed by a predecessor. One of the changes I have been asked to make involves a cell where input is restricted by values contained in a list. I was asked if the cell's value can be set by a conditional statement while still retaining the cell validation. The value to be selected based on the condition is in the list used for data validation. I've tried inputting the conditional statement but get an error stating that "The value you entered is not valid". Any advice would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Data Validation for Pocket Excel | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |