info in fields

B

Benoit

Hello,

I would like to know if it's possible to "refuse" access
to a field if other fields have not been filled out???

In example, if I wanna be able to add something in
field "A5", fields "A1" to "A4" must have the word DONE in
them.

Can you help me???

Thanks!!!
 
D

Debra Dalgleish

You can use Data Validation to check for entries in cells A1:A4 --

1. Select cell A5
2. Choose Data>Validation
3. From Allow, choose Custom
4. In the formula box, type the following formula:
=COUNTIF($A$1:$A$4,"Done")=4
5. (Optional) Enter an Input message or Error Alert.
6. Click OK

Note: Data validation is not fool proof -- users can paste invalid data
into the cell.
 
E

Earl Kiosterud

Benoit,

Data - Validation will not allow anything to be entered into A5 if the
following: Select A5. Data - Validation - Allow: Custom - Formula:
=AND(A1:A4="done")
 
E

Earl Kiosterud

Benoit,

=AND(A1="done" A3 = "done", ........B6="done", B8="done")

Seems to me there's a more concise way, but it escapes me at the moment. For
this one, you need to deselect "ignore blank."
 
Top