Mandatory cells?

  • Thread starter Thread starter Rue
  • Start date Start date
R

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.
 
I'd use an adjacent cell that was formatted in big bold red letters:

=if(b4="","",if(b5<>"","","Please enter something in B5"))
 
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
 
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.
 
Excellent many thanks :)


Dave Peterson said:
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
Click to expand...
 
Back
Top