• 0

Solved How Do I Find All Negative Values in a Excel With a Formula?

  • 0

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?


1 Answer

  1. 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.


    • 0