Solved How do I find all negative values in a excel with a formula?

October 15, 2014 at 07:30:05
Specs: Windows 7
How to find negative values in an excel worksheet Balance Sheet. I want to scan 100+ company balance sheets each in its own column on one worksheet. I need to find all the negative values. What formula can I use to find the negative values?

See More: How do I find all negative values in a excel with a formula?

Report •


#1
October 15, 2014 at 10:00:26
With out more info it is difficult to offer much assistance,
you could try something like this:

=IF(A1<0,"Neg","Pos")

If your value is in A1 and is less than Zero, it shows Neg
if your value is in A1 and is more than Zero, it shows Pos

MIKE

http://www.skeptic.com/


Report •

#2
October 15, 2014 at 10:08:48
✔ Best Answer
You can also use Conditional Formatting to "light up" all the values that are negative.

Select all your data in their columns,
don't select the whole column, just the cells with data in them.

This is for 2007:

On the Ribbon,
Click the Home tab
Click Conditional Formatting
Select Highlight Cell Rules
Click Less Than
In the "input box" enter Zero
Click OK

All your values that are Less than Zero will be colored.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question