Excel data validation another worksheet

I have an Excel sheet that I'm using to keep track of the status of certain things. I want to have a column which consists of cells containing a repeated drop down that allows you to select . red amber green unknown. I don't want any text in this cell, I just want a coloured block. Is this possible? I've tried playing around with data-validation-list . excel formatting excel-2003 list xls ...Effectively several hundred bars of data still. Perform the walk forward test once a month and adjust accordingly. Doing it in MT4 is a pain in the ass. Doing it in excel, at least for this system, isn't too difficult. ... You should also do at least a simple cross-validation like 10 fold . You split the data in 10 and optimize 10 times on all but a chunk, then test on that chunk. ...Daily posts of Excel tips…and other stuff ... the group of three buttons in the userform below. position-calculate-example. The worksheet below calculates the left position of each of the controls. Key assumptions: 1) each control is the same width; 2) the space between two controls is half the width of the control; 3) the layout is rational and logical ; and, 4) there are no more than 6 controls. Values: ...

In Excel 2010: Managing Multiple Worksheets and Workbooks, author Dennis Taylor shows how to share data between multiple worksheets and workbooks and gives tips for adding, moving, and navigating worksheets and workbooks efficiently. ...Understanding the user interface of MS Excel 2010 and the customization of ribbon by adding tabs and groups; Entering data in a worksheet; working with template and cell contents, formatting numbers, rows and columns; and managing ...I have been searching and found instruction on setting up a validation list but wasn't able to find the added feature I would like to add to my list. I have cells setup with validation list and using defined list for the source. ...

The content of cell A1 was driven from Data Validation pulling information from a defined list on another spreadsheet. The content of cell A2 was also driven from Data Validation but it's list content was defined based on the selection made in cell A1. ... Also a colleague opened up my file in open office as was able to access the data validation for this cell. Unsure why excel keeps giving me the error "The selection contains more than on type of validation. ...David an alternative for your second query is to implement a data validation rule for Column E. Select Column E; From menu select Data>Validation>Allow 'Custom' and in Validation formula enter the below and hit OK =AND,LEN= 10) ... occurs in cell A1 , I use = -LEN)) / LEN But now I want to . . . of workbooks with just one worksheet each when you're done? in Excel Programming ...Data Validation In Excel 97 Microsoft introduced a cool new feature called Data Validation. It can be found under Data on the Worksheet Menu Bar. Its purpose is to help stop entries into cells that are not within the criteria we set. ...