Only be able to write in a cell if another has content in it... PLEASE HELP

[ramghai]

Hey,

I'm creating a BMI calculator in MS Excel 2010.

I worked out the formula for calculating the BMI... but my problem now is:

There is a cell in which the user can write a target BMI (what they want to achieve). What I want is that the user should only be allowed to write in that cell if there BMI has already been calculated.

Thanks for any help!!

 

[RonB1111]

Try Data-Validation-Custom for the target BMI cell where, if the calculated BMI is in cell C1, enter this formula and uncheck "Ignore blanks":
=C1>0

 

[ramghai]

Try Data-Validation-Custom for the target BMI cell where, if the calculated BMI is in cell C1, enter this formula and uncheck "Ignore blanks":
=C1>0

no luck there

thanks for the try anyway!

 

[RonB1111]

It works on my test. What does the calculated BMI cell display when it hasn't been calculated yet?

Please confirm you selected the target BMI cell for data validation, that you changed C1 to the cell containing the calculated BMI, and that you unchecked the "Ignore blanks" box. After you set up the data validation, what happens when entering a number in target cell both when the calculated cell is and is not calculated?