View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gerry Verschuuren Gerry Verschuuren is offline
external usenet poster
 
Posts: 18
Default 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