Hide a row based on one cell's condition

B

Brian

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?
 
D

Dave Peterson

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.
 
Top