Home/ Questions/Q 1700
Next
Answered
computing
  • 6
Asked: 2021-10-24T06:16:02+00:00 In:

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

  • 6

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?

Share

    1 Answer

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

      • 0