data validation

I have a fairly sizeable workbook with a lot of named ranges, many of which are probably redundant which I'd like to delete. It's fairly routine to establish if a named range is used in a Formula or in any part of the VBA code within the workbook, but I can't think of a way to work out if a...

I have a excel file that I use to give as a test for the students. If has 2 Sheets. In Sheet 1 There is a MCQ, with 4 options, The Column A has the questions, followed by Column B-E with the 4 options and the Column F Has the right answer to that question and Column G uses the cell for the...

Hi beautiful people, I have a problem with a file, because I can't figure out how to make a data validation that does what I need. So, I want the data validation in cell A1 I have cell B1, where I can have it empty, or with a value(number) Data validation that I need: If cell B1 is empty...

I'm trying to create data validation rule that will change cell color depenidng on percentage of the value from the cell above e.g. G7/G6>0.8 change cell color to green, G7/G6>0.5 red etc. How do I create a formule in data validation that will apply this rule to all selected cells without...

Hello to everybody I have found the below very useful code from Contextures Excel Resources to Help You Succeed Option Explicit ' Developed by Contextures Inc. ' www.contextures.com Private Sub Worksheet_Change(ByVal Target As Range) Dim rngDV As Range Dim oldVal As String Dim newVal As...

Hi all, I have a series of drop-down lists created via data validation which pull from a separate sheet of dynamic lists that are driven by a series of rules. In other words, my sheet consists of a series of conditional drop-down lists, each one affecting the available options in the lists that...

Hi All, I struggled a bit with the title - so I'll try to explain more clearly. I have created a Table in Excel, which I intend to share with a selection of users to populate. This will result in a indeterminate number of rows being populated. Each column in my Table (10 columns in total)...

I have several ranges of cells on multiple sheets that I have manually applied both Conditional Formatting (CF) & Data Validation (DV). However, only some ranges actually work. I've also tried this by recording a macro for the CF and then using the macro to save time and avoid any errors. When I...

I have a spreadsheet that we are trying to build dependent dropdowns for several values. Column A is the 34 Organizations. Each of those 34 Organizations has a unique list of Owners, Departments, Areas, and Accounts. I have limited the the sample file to 10 organizations. The desire is to be...

Is there a way to look up a name OR number in a data validation list but only let the user select the number and then have the associated number populate in the adjacent cell? My goal is for users in a file to be able to see the project numbers and/or names (some users search by names and some...

Hi, i am working on a new employee performance evaluation form. Managers will fill the form for each of their employees semi-annually (attached). Each employee should have a minimum of 5 objectives and a maximum of 10 per each 6-month period. In the old evaluation form, each objective had a...

I am working on a shared spreadsheet for tracking and I need users to ONLY be able to enter a value that is LLNNNNN-NN (letters and numbers) and in another column (different data) LNNNNNNN-NN. Both are combos of letters and numbers but I need users to only be able to enter it in these ways. For...

Hello Everyone, I am working on a project using MS Excel 2021 data is organised as tables and stuck at these two problems as follow: 1. I need a setup the data validation will check the entered quantity in the "Qty" column of the "Invoice Detail" sheet against both the...

Hi guys, I am working on a project for my work which is a form that users can use to help them make decisions etc. I have this code that provides the ability to make multiple selections from a data validation list, so instead of the default excel position of being able to select one option...

A user enters: 1) The Start date of the month in Cell B1 2) The joining date (in case of a new employee) in Cell B2 3) Number of days worked in the current month in Cell B3 which has a custom data validation check as follows...

Anything I try gives me the error "the list source must be a delimited list, or reference to single row or column" What I have now is something like =IFERROR(CHOOSE(IF($AC1="Update Location",1,IF($AC1="Update Source",2)),SUMMARY!$B$17:$B$226,Master!$X$2:$X$1048576),"") where if Update...

I am running Excel 365. I have two named tables, one is called "Inquiry" and the second is called "JO." This is a customer service type database, where first we get an Inquiry, which we log in the Inquiry table in the column named "Inquiry Number." At some point, a decision is made on what to...

I want to add an array constant as name. Then I wish to use that name in data validation list. Does anyone have solution for this?

On one PC I have the following code fails and raises the '50290' run-time error. The model range is a data validation dropdown list on the same worksheet. If I remove the data validation, it works. What is causing the list to hang the process on this one PC? This script previously worked for...

Hi I have a dropdown list I created using the data validation option based on list I have in another sheet. I was wondering if I could also prevent users from selecting a duplicate value from the dropdown list within the same cells.