Cell Validation

[murugavelmsc]

Hi Experts,

I have developing a excel application with the following scenarios


Group A: Cell A, C, D, F
Group B: Cell B, E, G, H

row no: active cell

If users enter value in cell B or E or G or H without entering values in Group A (Cell A, C, D, F).

It throws a error alert to enter the Group A Cell (A, C, D, F)
Once the users enters all Group A Cell (A, C, D, F) cells, it allows to enter the value in Group B.

I need your help on this.

Please help me out its urgent.

Thanks,
Murugavel S

[dilipandey]

Hi Murugavel,

See the attached file where I have used counta function in data validation

cell validation.xlsx

Regards,
DILIPandey
<click on below * if this helps>

[murugavelmsc]

Dilipandey,

Excellent. But i want in active cell row.

Thanks,
Murugavel S

[dilipandey]

okay.. you need to give a example for this.. and then we can use something like if activecell to one cell left and two cell right etc should be filled in and then only activecell should accept value.

Regards,
DILIPandey
<click on below * if this helps>