Conditional Formatting
 

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

Conditional Formatting
 

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

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

Fellow Wanderer wrote:

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

--

Dave Peterson

Conditional Formatting
 

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

"Dave Peterson" wrote:

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

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

Fellow Wanderer wrote:

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

--

Dave Peterson

Conditional Formatting
 

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

Fellow Wanderer wrote:

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

"Dave Peterson" wrote:

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

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

Fellow Wanderer wrote:

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

--

Dave Peterson


--

Dave Peterson