 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / August 2006DATA VALIDATION
IF I USED DATA VALIDATION TO CREATE A LIST. CAN I LINK TWO LISTS TOGETHER. ie: LIST 1 IS ONLY COLORS, AND LIST 2 IS FRUIT. CAN I MAKE THE LISTS LINK SO AN ERROR POPS UP IF I TRY TO SAY I HAVE A PURPLE, APPLE? WHEREAS THE PROGRAM KNOWS, BECAUSE MY LISTS ARE LINKED THE ONLY COLOR THAT CAN BE BROUGHT DOWN IN THE FIRST LIST IS RED. IF I TRY TO USE PURPLE IT WON'T ALLOW ME, OR AUTOMATICALLY CHANGE IT TO THE COLOR RED. One way: fit a table: A B C ------------------------------ RED YELLOW GREEN ------------------------------ Apple Banana Grapes Peer Give a name: the range "Apple" is called "RED"; the range "Banana" is called "YELLOW"; the range C2:C3 is called "GREEN". Then, in column A put the validation: A1:C1. The last step: in column B put the validation: =INDIRECT(A1). This way, once is selected in A1 "RED", automatically in B1 is allowed only the value "APPLE", and so on. Roberto : IF I USED DATA VALIDATION TO CREATE A LIST. CAN I LINK TWO LISTS TOGETHER. : ie: LIST 1 IS ONLY COLORS, AND LIST 2 IS FRUIT. CAN I MAKE THE LISTS LINK : SO AN ERROR POPS UP IF I TRY TO SAY I HAVE A PURPLE, APPLE? WHEREAS THE : PROGRAM KNOWS, BECAUSE MY LISTS ARE LINKED THE ONLY COLOR THAT CAN BE BROUGHT : DOWN IN THE FIRST LIST IS RED. IF I TRY TO USE PURPLE IT WON'T ALLOW ME, OR : AUTOMATICALLY CHANGE IT TO THE COLOR RED. Please stop shouting, I have a headache. Sentence case is the accepted norm, whereas CAPITALS are considered to be SHOUTING!! -- Saruman --------------------------------------------------------------------------- All Outgoing Mail Scanned By Norton Antivirus 2003 --------------------------------------------------------------------------- > IF I USED DATA VALIDATION TO CREATE A LIST. CAN I LINK TWO LISTS TOGETHER. > ie: LIST 1 IS ONLY COLORS, AND LIST 2 IS FRUIT. CAN I MAKE THE LISTS LINK > SO AN ERROR POPS UP IF I TRY TO SAY I HAVE A PURPLE, APPLE? WHEREAS THE > PROGRAM KNOWS, BECAUSE MY LISTS ARE LINKED THE ONLY COLOR THAT CAN BE BROUGHT > DOWN IN THE FIRST LIST IS RED. IF I TRY TO USE PURPLE IT WON'T ALLOW ME, OR > AUTOMATICALLY CHANGE IT TO THE COLOR RED. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.