ISBLANK, Validation Rule
Posted on 2014-02-03
Ok, I'm confused...
I am trying to setup a validation rule - a custom one...
Before I start setting up the validation,... I think a validation rule needs a TRUE/FALSE result. So on a separate worksheet - I tested out the "=ISBLANK(A1:A2)" and it returns FALSE all the time.
What am I missing here?
I have a group of cells that I selected - they can only have values typed into them IF cells (named cells) "ShiftStart" & "ShiftEnd" have values. If they don't, then the selected cells should NOT accept values.
Thank you in advance for your help!