Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell1 must be blank before cell2 can except date
Hello to all.
In column F, I have a date for a prelimenary contract and in column G is the date contract is acepted. I have cells doing calcs on G, only if it contains a date. What I need is something to say, "You can't enter a date here until you delete the date in F", when someone tries to enter a date in G. Some kind of validation formula? Thanks. Daniel |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell1 must be blank before cell2 can except date
Daniel,
A quick way using Excel features is to select Data then Validation, and in the Settings tab criteria use the following: Allow: Select "Date" from pulldown Data: Select "greater than" Start Date: enter the formula =F6+F6 (assuming the prelim date is in F5) Click on the Error Alert tab, make sure the Style is "Stop", enter a Title for the error, and then your message about "You can't enter..." Nothing fancy but it works. "Daniel" wrote: Hello to all. In column F, I have a date for a prelimenary contract and in column G is the date contract is acepted. I have cells doing calcs on G, only if it contains a date. What I need is something to say, "You can't enter a date here until you delete the date in F", when someone tries to enter a date in G. Some kind of validation formula? Thanks. Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) |