I have a spreadsheet where I would like to be able to hide selected
rows if a specific cell within that row meets a specific condition.
The conditional cell is a cell reference to another sheet within the
workbook.

Does anyone know if this can be done and if so how?

Thanks in advance for your advice.

Crownman

Maybe you can select the column and apply Data|filter|autofilter to hide/show
the rows you want.

Debra Dalgleish has some notes here:
http://www.contextures.com/xlautofilter01.html

Crownman wrote:
>
> I have a spreadsheet where I would like to be able to hide selected
> rows if a specific cell within that row meets a specific condition.
> The conditional cell is a cell reference to another sheet within the
> workbook.
>
> Does anyone know if this can be done and if so how?
>
> Thanks in advance for your advice.
>
> Crownman

--

Dave Peterson