PDA

View Full Version : Solved: Data Validation Code To Force Prior Cell Entry



BENSON
07-20-2007, 12:39 AM
Is there a formula that could be used in data validation to compell a user to complete an adjacent cell entry prior to entering a value in the next cell ? .I am working on a shift roster and I want the user to declare a start time before entering a finish time.

Thks for any help

unmarkedhelicopter
07-20-2007, 02:09 AM
=A1<>""

BENSON
07-24-2007, 03:57 AM
MANY THANKS