3
votes
1answer
108 views

show more than 8 items in the Data Validation drop down list in Excel

I have added a simple data validation to a cell but it only displays 8 items in the dropdown. Excluding the combobox solution and probably involving some WinAPI is there a way to make the drop ...
1
vote
1answer
226 views

Data Validation of a Comma Delimited List

I need a simple way of taking a comma seperated list in a cell, and providing a drop down box to select one of them. For Example, the cell could contain: 24, 32, 40, 48, 56, 64 And in a further ...
1
vote
1answer
50 views

Data Validation arrow hidden from freeze panes?

I've been searching with no luck about my issue of the data validation drop-down arrow being hidden by freeze panes. I have read multiple forum posts about Excel 97 having this as a bug, but fixed in ...
-4
votes
2answers
205 views

Custom Data Validation in Excel 2010 [closed]

I'm trying to make error messages appear when someone tries to enter the wrong data type in a certain cell with data validation in Excel 2010. Is there a feature or some sort of formula I can use? ...
1
vote
2answers
151 views

Excel: Reference Dropdown Cell in Countif Formula

I'm trying to substitute text in an excel formula with a cell reference to the text in a dropdown. First formula that yields the correct answer is: =(SUM(COUNTIFS('LP - All ...
0
votes
2answers
386 views

How do I require a cell in one column to have a value if a cell in another column (same row) has a value?

I'm trying to require a value to be populated in column A if column D has an amount in it. Column A can hold any type of value (text or numerical), column D can only be a number. So, for example, if ...
0
votes
1answer
2k views

Excel data validation to whole column

I want apply data validation list to a whole column in excel 2010. How can I do that with out copying the validation rule
1
vote
3answers
79 views

How can I avoid typing in a value which already exists in another range in Excel 2010?

I am working up a basic project tracking spreadsheet in Excel and would like to have two sheets - one which shows my active projects and one which shows my completed/cancelled/archived projects. I ...
1
vote
2answers
470 views

MS Excel data validator does not accept call to the custom macro

I have the working VB macro that validates the content. It takes two string parameters (cell value and regular expression) and returns either True or False. It uses CreateObject("VBscript.regexp") ...
1
vote
1answer
56 views

Enforce style of named list items in Excel 2010

I have a named list with some values which have their own style (e.g. different colors): However when I apply that list as a data validation and select some values, the styling disappears: : How ...
1
vote
1answer
604 views

How do I make a Data Validation drop-down exclude blanks?

Related: How can I use non-adjacent cells on another sheet for a Data Validation drop-down, and only show non-blank values? For now, I've worked around the above problem by re-arranging my sheet so ...
0
votes
1answer
593 views

How can I use non-adjacent cells on another sheet for a Data Validation drop-down, and only show non-blank values?

I have a few, non-adjacent cells on one sheet which I want to use as a Source for Data Validation in a cell on another sheet. However, it seems Data Validation doesn't natively permit this. So, I ...
3
votes
2answers
981 views

How do I create a data validation list WITHOUT using cells?

I have a simple data validation dropdown that I'm trying to do, but I DO NOT WANT to use cells to populate my list. Something similar to what's below, but this obviously isn't working. What ...
3
votes
2answers
1k views

Excel Conditional Formatting

Highlight all non-blank entries in a column, except for the column header, that do no fall in some range. Here's my attempt: ...
0
votes
1answer
74 views

excel: the name but not the contents of a named range is the only option shown in drop down list

I have a sheet 'orders' and a sheet 'lists.' In lists, I have a list of valid fruits: a1: fruits a2: apple a3: orange a4: someone may add something here at any time I have a named range ...
2
votes
1answer
537 views

Microsoft Excel validation based on adjacent cell

I have a two adjacent columns named Country and Rating. The Country column has a dropdown to select which country a DVD is being delivered to. It is using a list validation to create the dropdown: ...
1
vote
1answer
2k views

Conditional Data Validation

I've been taking a certification course on Excel. It's a beginner class but something caught my attention. Specifically, Data validation. We learned how to do it using the default conditions but I ...
0
votes
2answers
1k views

Excel 2007 vs Excel 2010: Data Validation values using Named Ranges and the INDIRECT function

I am running into a bizarre error in Excel that I am hoping someone can help me with. I have a macro-enabled workbook created in excel 2010. On the workbook are a series of radio buttons. When a ...
4
votes
3answers
9k views

Excel 2010 data validation warning (compatibility mode)

We have some legacy worksheets that were created in Excel 2003, which are used by LabVIEW-based test automation software. The current LabVIEW software can only handle the legacy .xls format, so we're ...