info in fields

  • Thread starter Thread starter Benoit
  • Start date Start date
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!!!
 
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.
 
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")
 
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."
 
Back
Top