Help on Custom Data Validation

J

JON JON

Dear NG,

What should be the formula in custom data validation so that when A1 is
empty no entry will be accepted in A2? Please no VB!

Regards,

Jon-jon
 
D

Dave Hawley

Hi Jon

I would have thought something like

=NOT(ISBLANK(A1))

But it doesn't work and it *seems* that a cell cannot be validated to
check if a cell is empty.

You could use a helper column, say Column B and then hide it. In this
column put;

=NOT(ISBLANK(A1))

Now in the cell that cannot accept entries, until A1 is not blank, use;

=A1

as the Custom formula.


** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 
D

Debra Dalgleish

Select cell A2
Choose Data>Validation
Choose to Allow:Custom
In the Formula box, type: =A1<>""
Remove the check mark from 'Ignore blank'
Click OK
 
Top