software

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, quot;You can't enter a date here until
you delete the date in Fquot;, when someone tries to enter a date in G. Some
kind of validation formula? Thanks.

Daniel
Daniel,

A quick way using Excel features is to select Data then Validation, and in
the Settings tab criteria use the following:
Allow: Select quot;Datequot; from pulldown
Data: Select quot;greater thanquot;
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 quot;Stopquot;, enter a Title
for the error, and then your message about quot;You can't enter...quot;

Nothing fancy but it works.

quot;Danielquot; wrote:

gt; Hello to all.
gt; In column F, I have a date for a prelimenary contract and in column G is the
gt; date contract is acepted. I have cells doing calcs on G, only if it contains
gt; a date. What I need is something to say, quot;You can't enter a date here until
gt; you delete the date in Fquot;, when someone tries to enter a date in G. Some
gt; kind of validation formula? Thanks.
gt;
gt; Daniel
gt;
gt;
gt;