How about just selecting that column and doing data|Filter|autofilter.

Then you can show cells not equal to 0.

wrote:

HI All,

How do I conditionally rows if a certain cell = 0? For example, if
any cell within range BA5:BA37 =0 then hide row. Any help will be
appreciated. Thanks.

James

--

Dave Peterson