| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional hiding of entire rows
Hi All
I was wondering if anybody knew how to hide an entire row or column based on a stated condition using a specific cell elsewhere on the worksheet. I know that it is possible to use [Format] Conditional Formatting to make the cell appear empty, but I want to hide the entire row or column so that it no longer appears on the worksheet. Is there a way to do this with or without using VBA? Thanks in advance and have a happy new year. Nick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use conditional formatting on all rows based on data | Excel Discussion (Misc queries) | |||
| Hiding rows | Excel Discussion (Misc queries) | |||
| Hiding of rows and columns | Excel Discussion (Misc queries) | |||
| HIDING ROWS IN PROTECTED WORKSHEETS | Excel Discussion (Misc queries) | |||
| How to change an entire row using conditional formating | Excel Discussion (Misc queries) | |||
Threaded Mode
