Mandatory cells?

[Rue]

Hi all

Is it possible make certain cells mandatory?
For example, I am trying to accomplish this;
If data in cell B4 is entered then user must fill in data B5

Thanks in advance.

 

[Dave Peterson]

I'd use an adjacent cell that was formatted in big bold red letters:

=if(b4="","",if(b5<>"","","Please enter something in B5"))

 

[D8.Consultor]

I never thought about doing this, but I found a solution.

In the cell that requires other cell to have something in it, use menu
Data->Validation, then Personalized and in the formula type
"=isnumber(targetcell)"

Where "targetcell" is the cell required to have a value in it.

I used isnumber() in this case, but I think you can go anyway you want
with this approach

 

[Dave Peterson]

I don't think that this will do what the OP wants.

This would make sure that the user could only enter something into the cell if
another cell was numeric--not make sure that if one cell is filled in, then the
other cell is filled in.

But maybe I read the question incorrectly.

 

[Rue]

Excellent many thanks

I don't think that this will do what the OP wants.

This would make sure that the user could only enter something into the
cell if
another cell was numeric--not make sure that if one cell is filled in,
then the
other cell is filled in.

But maybe I read the question incorrectly.



Dave Peterson