View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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