conditional format?

A

ajr81

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.
 
P

Pyrite

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