Pls help me!

  • Thread starter Thread starter mompmc
  • Start date Start date
M

mompmc

Hallo there!

I have a problem on locking some cells (eg: Area A) from preventin
user to continue input.

Let's make thing simple.
When I start input value to any cell of "Area B", I want all the cell
at "Area A" to be locked. no entry allowed.

and when I start input value to any cell of "Area C", I want all th
cells at "Area A and B" to be locked.

Can I done this with formulas, or I have to use VBA?

(01 file abc.xls attached.)

Can you help me! Thank you very much!

mompm

Attachment filename: abc.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45949
 
Hi
try the following for the cells A1, B1, C1:
- select cell A1
- goto 'Data - Validation'
- enter the following formula (category 'Custom'):
=AND(B1="",C1="")

- select cell B1 and enter the validation formula
=C1=""
 
Back
Top