Excel- show one cell depending on what's chosen in another cell

[HRingman]

A coworker left, and now I inherited a spreadsheet he had started working on. The spreadsheet has macros in it to create an adaptation piece. One of the cells is for orientation of the piece- either Straight, 45 degree, or Other. Under that, there's a box for angle. If Straight or 45 Degree is chosen for orientation, then the cell that says Angle, and the cell to enter the angle is also blanked out. If Other is chosen, then "Angle" appears, and the cell to put the angle in also appears.

Or that's how it was working, but I can't get it to do that anymore. Now even if Other is chosen, "Angle" doesn't show up. Does anyone know how to fix it?

TLDR: How do I get cells to show up or hide depending on what's chosen in drop-down on other cell?

 

[SkipVought]

hi,

TLDR: How do I get cells to show up or hide depending on what's chosen in drop-down on other cell?

Use an IF formula for a value to be something or nothing.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]