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
|