validation rule

for example >LLLL-99-99-99-LLL9999-LL## where L is ALPHA, 9 numeric, # can be either. example of cell passing this mask; "ABCD-10-20-45-ABC1234-AB00" a function would be best the have a column to flag the data column good/bad and perhaps where "bad" thanks for any guidance, Greg...

Hello, I am trying to create an expression that will control a users date input in reference to a pervious field. This is what I currently have: [Field 1]<=[Field 2]<=[Field 3]<=[Field 4]<=[Field 5] Field 1 has an expression/Validation rule of: <=Now() Essentially, I want the first field to...

Hello! I'm trying to create a quote template in Excel. The issue happens when sales wants to give a discount, but then give too big of a discount on the price. To solve this issue we've duplicated the price in another hidden cell and reference that cell in the validation rule. The idea is...

Excel 2010 question: I have a table that I'm trying to write a validation formula (using Excel formula and avoid VBA if possible)for. In the example table below - the "Assignment" given to the unique combination of "Account" & "Sub-account" for an over-lapping Start and End Date must be the...