Conditional Input Cells

  • Thread starter Thread starter gsullymorgan
  • Start date Start date
G

gsullymorgan

Can I do this?

I'd like to be able to have a logical cell referred to and from tha
determine whether to dispkay and accept input.

e.g.

A1 = "Are You Married" B1 = Yes/No

A3 = "Your Age" B3 = Input age

A5 = "Age of spouse" B5 = Input age

If B1 = No then I'd like to hide A5 and B5.

Thanks
 
Hi

hide as in hide the row - then no, you'll need to use code to do this,
however you can supress the display of the data in A5 & B5 by using the
following formula in
A5
=IF(B1="Yes","Age of Spouse","")
and in B5
=IF(B1="Yes","Input Age","")

will this do?

Cheers
JulieD
 
Back
Top