ExcelBanter - Hiding rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hiding rows (https://www.excelbanter.com/excel-discussion-misc-queries/184051-hiding-rows.html)

Glen

Hiding rows

Hi,

Wondering if there is a way to hide a row depending on the value of a
certain cell.
eg. if any cells in column C has "xxx" then hide entire row.
I'm guessing there is a way to do it using logic or conditional formats but
not sure what to use to hide the row.
--
Thanks

David Biddulph[_2_]

Hiding rows

Use Auto-filter
--
David Biddulph

"Glen" wrote in message
...
Hi,

Wondering if there is a way to hide a row depending on the value of a
certain cell.
eg. if any cells in column C has "xxx" then hide entire row.
I'm guessing there is a way to do it using logic or conditional formats
but
not sure what to use to hide the row.
--
Thanks

Gord Dibben

Hiding rows

Formulas cannot hide rows or cells.

CF can change font to white.

To actually hide the row(s) you need autofilter or VBA

Gord Dibben MS Excel MVP

On Thu, 17 Apr 2008 00:15:00 -0700, Glen wrote:

Hi,

Wondering if there is a way to hide a row depending on the value of a
certain cell.
eg. if any cells in column C has "xxx" then hide entire row.
I'm guessing there is a way to do it using logic or conditional formats but
not sure what to use to hide the row.

All times are GMT +1. The time now is 05:08 AM.