Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Validation
Please I have thousands of rows across multiple columns. I need to validate
date in m/d/yyyy format. Coding will really help me as I use some formula that does not help across multiple date. If possible to color any date not in the m/d/yyyy format. Sometimes I get error like d/m/yyyy or m/d//yyyy or d//m/yy or sept 2000. Please help me be able to identify these date problem. Its really making me get so many error files. Thanks a big bunch!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Validation
I'd do it this way:
1) start macro recording 2) got to format | conditional formating and enter - cellvalue not between 1.1.1950 and 1.1.2000, colour red -- ok 3) stop macro editor und check the produced code - in my case: Sub Makro1() ' ' Makro1 Makro ' Makro am 17.06.2008 von Franz Erhart aufgezeichnet ' ' Selection.FormatConditions.Delete Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlNotBetween, _ Formula1:="18264", Formula2:="36526" Selection.FormatConditions(1).Font.ColorIndex = 3 End Sub 4) adapt und use this piece of code in your program as needed regards franz erhart. "Yossy" wrote: Please I have thousands of rows across multiple columns. I need to validate date in m/d/yyyy format. Coding will really help me as I use some formula that does not help across multiple date. If possible to color any date not in the m/d/yyyy format. Sometimes I get error like d/m/yyyy or m/d//yyyy or d//m/yy or sept 2000. Please help me be able to identify these date problem. Its really making me get so many error files. Thanks a big bunch!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Validation for Date of Birth | Excel Programming | |||
Date Validation - Must equal Sundays date | Excel Discussion (Misc queries) | |||
Date validation | Excel Discussion (Misc queries) | |||
Date Colum Date Formatting & Validation | Excel Programming | |||
date validation | Excel Programming |