hide row when adjacent column has zero(0)

  • Thread starter Thread starter beesleyh
  • Start date Start date
B

beesleyh

I'm working with a workbook that has several worksheets that are all
referenced to one another. In some of the worksheets I have a specific
breakdown by region of the names of counties and in the column next to the
county name I have a value of the number of books they want. I'd like to be
able to hide the county rows that want zero(0) books (there is a zero(0) in
the column adjacent) so that way when I print the worksheet I won't see the
counties that don't want any books. I know this must be a conditional
formatting question but it's been awhile since I've taken an Excel class and
so I'd appreciate any help. Thanks!
 
Why not filter the range, then use the appropriate filter button to exclude
Zeros?

HTH
Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup into 2 columns 2
Sorting Macro 4
Hide columns based on row values 2
Minimum nonzero value for non-adjacent columns 9
Hiding error message 3
sumproduct question 3
EXCEL FORMULA 6
Sum? IF? function 3

Back
Top