conditional format?
 

I know how to get a cell to format or change content based on the information
entered in another cell (conditional format).

Is there anyway to get a range of cells to appear or disappear based on the
content of a cell?

For example of A1 is yes, then cell B2 appears. If A1 is no, then B2 does
not appear.

conditional format?
 

You could turn the font white and then conditional format it to turn black if
A1 = Yes

"ajr81" wrote:

I know how to get a cell to format or change content based on the information
entered in another cell (conditional format).

Is there anyway to get a range of cells to appear or disappear based on the
content of a cell?

For example of A1 is yes, then cell B2 appears. If A1 is no, then B2 does
not appear.