Help on Custom Data Validation

[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

 

[Andy B]

Hi

Try
=A1=""
as your formula in Data Validation for A2

Hope this helps.

 

[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 ***

 

[JON JON]

Never Got it. If anybody would be interested I use =LEN(A1)>0

 

[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