Is it possible to make the visibility of a row conditional on a value in a cell of the row? For example, can a row be hidden if the first cell of the row contains the value 5 but otherwise the row is visible?
Ditto question for columns.
The question comes up in the context of time series that are step functions.
Any help would be appreciated. I couldn't find an answer in Excel 2007 Help.
Edited by novicee, 06 November 2011 - 12:18 AM.