Hi,



I Need to do a formula for hide a row that contains Minus(-) values. Please help for this, Well I show you an example.

Column 01 Column 02
Charts 200
Bank 800
Apple -100


Orange -20
Sharp 50

What i need to do is a formula (not VBA) to select minus(-) values and hide that entire row.

Thank you.

You can't do that by formula, but you can use Auto Filter, column B, Number Filters, Greater Than 0.

I tried it, It's Working, Thank you