Help on Custom Data Validation

  • Thread starter Thread starter JON JON
  • Start date Start date
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
 
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 ***
 
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
 
Back
Top