data validation

hi anyone can help me on below, I want users to enter specific text (AB, DO, SL) and numbers (-10 to 20) in the cell range(A1:B10, A20: B30). Users should be able to enter only allowed data. if not cell should be clear. I don't want to use data validation impact I need VBA codes. please help...

Hello, I need code for data validation to set color in the cell In the picture I explained Thank you in advance for your reply

In F5 ,I have a List. if any one select this values "Book1","Book2" and "Book3".. i have to show some error using data validation "=OR((F5<>"Book1"),(F5<>"Book2"),(F5<>"Book3"))" why this code is not working??

Hello, I am using Power Query to pull multiple data sets into a single workbook. I have a table within that workbook that contains a dropdown. What is selected in that dropdown determines how the data pulled in by Power Query gets filtered. See attached for further explanation. It works...

I am trying to get some data validation to work based on if a certain value is entered to not allow it and notify user. I see all the options are to compare to “allowed values” but I would like to prompt user and not allow just the letter C to be entered in some ranges of cells. How would one go...

This is my first post here, so sorry if I made any mistakes (this forum has helped me a lot before tho, thanks!). I'm trying to make a macro that will delete everything within a range of cells, but I'm running into a weird issue. There's a couple of checkboxes and a picture that don't get...

Hi, I'm making a sheet to easily click together invoices/offers. Therefor i've got a data-sheet which has all products on it (per row), with also colums for each 'color' of this product, and the prices of these combinations. Description Yellow Blue Red Table $ 10,00 $ 15,00 $ 20,00...

I have a data validation set in 3 columns so that the answers will remain consistent, and I don’t want this to change. I want cell D to be required if cell B has an answer selected (which will always be “Yes” because of my data validation restriction). But I don’t want cell D to be required if...

I have a workbook with several sheets. I have a power query that consolidates the values from those disparate sheets into one consolidated view. On each of those sheets is a column "Pass / Fail", and the values of that cell are derived from a dropdown data validation list. When the query runs...

Hi all, I have to enter data validation rule in a cell (i.e. Cell A1) that it allows value 0 (Zero) or number value greater then in cell B1. Data must be in decimal points. The whole idea is i want cell A1 value not less then cell B1. But it can be zero (Cell A1= 0 or greater then B1) help...

I've been tinkering for a while, but just can't seem to get this to work as desired. I have multiple tables in a workbook: TblFuel TblVehicles TblPlant_Machinery TblMaterials TblLabour I'm creating a quote page where the initial selection is for one of these item types(Fuel, Vehicle...

Hello All, I do hope that someone can help me with this problem I am having... What I am trying to do is set a "Whole Number" verification on a calculator field..... The Calculation is on the "Number of Boxes" which is "Qty Ordered" / "Box Qty" So what I am looking to do is set a...

Hi Everyone, I have an Excel table. I am trying to perform a multi-column data validation. I am trying to use the COUNTIFS function like so: =COUNTIFS([Supplier],C2,[Supplier_Code],D2)<=1 The goal is to ensure that the data entered is not a duplicate. The combination of [Supplier] and...

I was wondering is it possible to lockdown a data validation list. i.e Make a dropdown list available for cells A2:A100. Then protect the sheet so that A2:A100 can use the dropdown available but that list to be locked so no one can either take the data validation off or change the list...

Hi, I am hoping you could assist me please. I have two (2) queries I need some help with. The first query is that I need selected cells to auto populate based on the Nomination Date (K14). I need Outcome Date (K15) to auto populate based on the date populated in K14 and plus 28 days; I also...

Hello, I have been trying to find a solution to creating a Data Validation List that shows a default value (the top item in the list). I found a solution on this board that sort of works. Is it Possible for a Drop Down Menu to have Default Selections? Post #3 seems to work....but only to a...

Hi All, First time poster, long time reader. I have been having an issue with a formula I am inputting into the data validation widget to create a dynamic dependant dropdown error. The formula is as follows: =OFFSET(Setup[[#Headers],[Savings]],1,MATCH([@[Expense...

Does anyone have a solution to formatting mm:ss without the AM/PM after it. I'm creating a spreadsheet where I need to put time as an input, say for a race where something like 10:30 would be 10 minutes and 30 seconds. There are then some calculations done on the time which says if time is below...

I am trying to figure out a way in VBA to lock cells in columns A:C if the corresponding cell for that row in column D reads "Complete". So If D2 reads "Complete", A2:C2 will be locked, if D3 reads "Complete" then A3:C3 will be locked, and so on. Similarly, if D2 reads "Open" or is blank, cells...

Is there a way to set a Data Validation to CAPS and LIMIT meaning I'm using Excel, Data Validation, Custom, =AND(EXACT(A3,UPPER(A3)),ISTEXT(A3)) this makes everything CAP. But I also want to limit how many charters allowed in this area meaning 10 or less... so far I figured out how to do one...