validation rule: not equal blank

[cornepiek]

hi all

can someone help?

i need to setup something like a validation rule to do the following:

if adjacent cell not blank, cell value cannot be blank

EG:

if E1 = blank, then E2 allowed Blank
if E1 <> blank, then E2 not allowed Blank

please help

 

[ayazgreat]

I have tried this formula in (E2)data validation and this works fine but I do not know if I am right or not.

=IF(COUNT(E1)>0,COUNT(E2)>0,IF(COUNT(E1)="",COUNT(E2)="",""))

 

[cornepiek]

thanks

i had to tweak it a bit to fit better, but it works