writeprotect a cell dependet to the value in the cell before

F

Frank

Me again...

is it possible to allow/disallow writing to a cell dependent what the value
in the cell before is?

Sample:

A5 = Validation List
B5 = VLockup value (dependet to value choosen in list before - just learned
that here yesterday) :)
C6 = Depending tha value choosen in the validation list in A5 List coming
from sheet "Data") C6 must be write enabled or protectet

Smaple with values

Lists
"Voucher" --> "1 Voucher"
"Invoice" --> "USD 100"
"Hourly" --> "5 hours"

A5 = validation list
B5 = dependet value got from Vloockup
C6 = if voucher or hourly is choosen in A5 cell must be write protectet

complicated?
 
J

Jim Rech

The best you can do without a macro, I believe, is a formula cell
validation. You'd pick Custom from the "Allow" list and enter a formula
like this:

=AND(A5<>"",A5<>"hourly",A5<>"voucher")

Uncheck the "ignore blank" box.

--
Jim Rech
Excel MVP

| Me again...
|
| is it possible to allow/disallow writing to a cell dependent what the
value
| in the cell before is?
|
| Sample:
|
| A5 = Validation List
| B5 = VLockup value (dependet to value choosen in list before - just
learned
| that here yesterday) :)
| C6 = Depending tha value choosen in the validation list in A5 List coming
| from sheet "Data") C6 must be write enabled or protectet
|
| Smaple with values
|
| Lists
| "Voucher" --> "1 Voucher"
| "Invoice" --> "USD 100"
| "Hourly" --> "5 hours"
|
| A5 = validation list
| B5 = dependet value got from Vloockup
| C6 = if voucher or hourly is choosen in A5 cell must be write protectet
|
| complicated?
 
F

Frank

hm dont understand that...
how about making it even more simple

Can I make a string like:

When G11="invoice" Then G12 =*enter billing adress" if not G12 = "do not
fill out this field"

how would the formular look like?
 
M

Myrna Larson

You could do something like this, but I assume that G12 is NOT the cell where
the billing address is to be entered. i.e. G12 just serves as a "reminder"
cell.
 
Top