Share via

HOW TO COLOR/HIDE A CELL IF THE NUMBER IS NEGATIVE

Anonymous
2023-12-08T16:21:59+00:00

I'm creating a debt payoff spreadsheet and if the "amount owed" is a negative number, I'd like to fill the cells below it white so I don't see the "negative" balances when the amount owed has become negative. I hope that makes sense; I wasn't sure how to ask it.

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2023-12-08T16:32:43+00:00

    Select the range.

    On the Home tab of the ribbon, select Conditional Formatting > New Rule...

    Select Classic.

    Select 'Format only cells that contain'.

    Leave the first drop-down set to 'Cell Value'.

    Select 'less than' from the second drop-down.

    Enter =0 in the box next to it.

    Click Format...

    Activate the Number tab.

    Select Custom.

    Enter ;;; in the Type box.

    Click OK until you're back in Excel.

    7 people found this answer helpful.
    0 comments