Conditional Formatting


G

Guest

I have the following table and would likie to know if there is a way to have
the rows with "0" or null in column B to be hidden?

Col A Col B
Apples 26
Oranges 33
Pears 0
Bananas 21
Grapes 56
Limes
 
Ad

Advertisements

D

Dave Peterson

Can you select column B and do data|filter|autofilter

Then filter to show the non-zero/non-blank cells/rows?
 
G

Guest

Thanks! I knew there had to be an easy way to do this. It took me a minute
to figure out the "does not equal" option, but that's exactly what I needed.

Cheers
 
Ad

Advertisements

D

Dave Peterson

maybe you could have used is greater than 0???

Fellow said:
Thanks! I knew there had to be an easy way to do this. It took me a minute
to figure out the "does not equal" option, but that's exactly what I needed.

Cheers
 

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

Top