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.