Excel query about Lists
Hi,
Can you help me out to find out a solution about the following..
I have 4 columns in my worksheet,each of them is validated with List of
certain range.I have to check the left cell is blank or not,if the
previous cell(row wise) is not blank then the next cell will allow the
list,otherwise thoe cells will not accept any value.For the 3rd
column's cell ,previous 2 cells has to be checked and follows.
How can I implement that?
Thanks
Regards,
Nil
|