View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Daniel
 
Posts: n/a
Default 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