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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing cell formulas 1
Excel Conditional Formatting 1
Format Painter in Excel 2007 4
Conditional Format Range of Cells 3
Cell Coloring 1
copying conditional formats 2
Conditional Formatting in Excel 2007 1
Hide Cell content from Printing 2

Top