Hide a row based on one cell's condition
 

Is it possible to hide a row based on a condition?
For example...if I have dollar amounts in cells A1, B1, and C1....and I want
to hide any rows where the amount in the first cell is 0, can I?

I think the easiest way is to apply Data|Filter|Autofilter to that range.

Then you can filter to show values in that column that are greater than
(different from???) 0.



Brian wrote:

Is it possible to hide a row based on a condition?
For example...if I have dollar amounts in cells A1, B1, and C1....and I want
to hide any rows where the amount in the first cell is 0, can I?

--

Dave Peterson