data validation;formula

Hi Can someone help me with a issue a am battleling. I am pretty new to the advance formuals in excel so pleas ebear with me. This is the scenario I Created a excel workboot with one sheet.What this file should do is check for duplicates and warn me if i have reached zero. So,I have One...

Hi I have a spreadsheet which monitors the hours employees work - one of the rules is that an employee must have 12 hours rest between shifts... I am using the below Data Validation formula in column I to highlight when an employee has less than 12 hours rest and an alert to appear...

Hi , hope someone can help me with following Data validation problem: Problem 1: I have data validation in a matrix allowing a user to enter only a N or R. By processing a macro I later change the N's into X's and remove R's. When the file is saved, it is send back to the user for a next...

Hi There Is it possible to apply Data Validation to an empty cell based on the calculations in another cell? I currently have the following: H6 contains total hours worked in one shift (which is calculated with a formula) I6 contains total journey time (which is manually entered) J6 Contains...

Hi, The below code i had used to validate the data entered in corresponding fields but the code is not working only numeric condition is working and i had added data validation at the end of the command button before last line. Private Sub datavalidation() If Not IsNumeric(TextBox3.Value)...

Hi, I have an automatically updated list going down a column. (100 rows in the column have a formula and it is basically saying it equals the next figure in the list that has been selected until there are no others and it then =""). =IF(ROWS($L$3:L3)<=(COUNTIF('Purchases...

I had someone who is brilliant come up with this idea and it works like a charm but the problem is that the Array is in memory and when I close Excel and reopen it the Array is gone and the Data Validation is lost. Below is the code and you will see the array, "ary" is converted into the string...

I was making good progress with this, but seem to have run into a roadblock now and can really use some help. I am trying to make it so that I have a drop-down menu that will have data based off of what is in cells B6 and C6. Cell B6 will have two options (in a drop-down); "Minot AFB" and "91...

Looking for a way either via data validation or VB code to prevent user entry of a specific codes beyond the given amount. </SPAN></SPAN> So if cell F42 has a 3 then user should not be able enter more than three vacation carryovers “VC” within the calendar table. The way it is setup. Code “VC”...

Hi There I'm an average user of Excel and VBA and have come become stuck with some code I'm trying to get working. I have a insert rows button that inserts a new row, this includes adding in some data validation among other things. This is fine until I try to make my formula dynamic. This...

Hi Friends, I want to put a data validation rule on a cell. My requirement is as follows [Assuming that I want to apply this rule to Cell A1] If A2 is not blank then User should get a dropdown to Select "YES" or "NO" as a value for Cell A1. If A2 is blank A1 should be blank as well. Can...

I am trying to come up with a way to limit the number of codes ("V", "VC" and "P/H") that can be entered on the following vacation calendar. This is to prevent from going over the allocations provided below. Vacation <tbody> * B C D E F G 1 Vacation Schedule * * * * * 2 *...

Is this possible? I have a cell that outputs a percentage between 0%-100% in cell H13. I'd like to check if cell H13 is within this range, if not, produce an error message and/or highlight the cell indicating is is not. The formula I'm using in the data validation dialog...

hello Forum, i have an interesting question related to data validation. i'm trying to do the following: when a value from another column meets a criteria the information in the celue to be filled in automatically as "ok", otherwhise to let the user choose from 2 different alternatives. i've...