Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide rows with conditional formatting
Is it possible to hide a ROW with conditional formatting? I know you can hide
cell values by using a custom number format: ;;; However, that makes the content of the cell unvisible, but it does not hide the entire row. Perhaps my request is not possible outside VBA. I don't need a VBA solution (I have one), but I would like to achieve this result with conditional formatting only. Thanks for your help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide rows with conditional formatting
Hi Gerry,
No, it's not possible to hide a row with conditional formatting. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Gerry Verschuuren" wrote in message ... Is it possible to hide a ROW with conditional formatting? I know you can hide cell values by using a custom number format: ;;; However, that makes the content of the cell unvisible, but it does not hide the entire row. Perhaps my request is not possible outside VBA. I don't need a VBA solution (I have one), but I would like to achieve this result with conditional formatting only. Thanks for your help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide rows with conditional formatting
If you really mean hide the row by making the rowheight 0, then nope, not
through format|Conditional formatting. You may want to look at data|filter|autofilter. This may work for you and would be a "macro-free" solution. Gerry Verschuuren wrote: Is it possible to hide a ROW with conditional formatting? I know you can hide cell values by using a custom number format: ;;; However, that makes the content of the cell unvisible, but it does not hide the entire row. Perhaps my request is not possible outside VBA. I don't need a VBA solution (I have one), but I would like to achieve this result with conditional formatting only. Thanks for your help -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide rows with conditional formatting
Yes, I know about that alternative, but I was just hoping you could set the
row height. Thanks anyway. "Dave Peterson" wrote: If you really mean hide the row by making the rowheight 0, then nope, not through format|Conditional formatting. You may want to look at data|filter|autofilter. This may work for you and would be a "macro-free" solution. Gerry Verschuuren wrote: Is it possible to hide a ROW with conditional formatting? I know you can hide cell values by using a custom number format: ;;; However, that makes the content of the cell unvisible, but it does not hide the entire row. Perhaps my request is not possible outside VBA. I don't need a VBA solution (I have one), but I would like to achieve this result with conditional formatting only. Thanks for your help -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide rows with conditional formatting
That's what I was afraid of. Thanks for confirming my guess.
"macropod" wrote: Hi Gerry, No, it's not possible to hide a row with conditional formatting. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Gerry Verschuuren" wrote in message ... Is it possible to hide a ROW with conditional formatting? I know you can hide cell values by using a custom number format: ;;; However, that makes the content of the cell unvisible, but it does not hide the entire row. Perhaps my request is not possible outside VBA. I don't need a VBA solution (I have one), but I would like to achieve this result with conditional formatting only. Thanks for your help |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide rows with conditional formatting
No to hide row or reset height but you can use to change font.
-- Don Guillett SalesAid Software "Gerry Verschuuren" wrote in message ... Is it possible to hide a ROW with conditional formatting? I know you can hide cell values by using a custom number format: ;;; However, that makes the content of the cell unvisible, but it does not hide the entire row. Perhaps my request is not possible outside VBA. I don't need a VBA solution (I have one), but I would like to achieve this result with conditional formatting only. Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use conditional formatting to hide or delete rows? | Excel Worksheet Functions | |||
Using VBA to Conditional Hide Rows? | Excel Discussion (Misc queries) | |||
Conditional Formatting to Hide Rows or Columns? | Excel Discussion (Misc queries) | |||
Conditional Hide/Unhide Rows | Excel Discussion (Misc queries) | |||
CAN I HIDE ROWS WITH CONDITIONAL FORMATTING? | Excel Discussion (Misc queries) |