Featured Article

Mastering Excel: Negatives in Color - A Comprehensive Guide

Russell Aug 07, 2026

Have you ever found yourself working in Excel and wished you could color negative numbers for easy identification? By applying conditional formatting, you can add visual cues to your data, making it more comprehensible and well-organized. Here's a step-by-step guide on how to color negative numbers in Excel.

Excel – Negative Number Color to Red & Positive Number to Green with Conditional Formatting
Excel – Negative Number Color to Red & Positive Number to Green with Conditional Formatting

First, ensure you have the latest version of Microsoft Excel. This guide applies to Excel 2013, 2016, 2019, and the newer version, Excel 365. If you're using an older version, you might find that some functionalities are not available.

How To Highlight All Negative Numbers In Red In Excel
How To Highlight All Negative Numbers In Red In Excel

Understanding Conditional Formatting

Conditional formatting is a powerful Excel tool that allows you to change the cell formatting based on the content of the cell. It's like giving Excel instructions to apply specific formatting rules based on given conditions.

How to change positive numbers to negative in Excel?
How to change positive numbers to negative in Excel?

There are several types of conditions you can apply, and Excel provides a vast gallery of formatting options to choose from. In this case, we will focus on using the "Highlight Cells Rules" option to format negative numbers.

Opening the Conditional Formatting Dialog Box

Color-Coded Drop-Down Lists in Excel – Make Data Entry Smarter
Color-Coded Drop-Down Lists in Excel – Make Data Entry Smarter

Every conditional formatting rule begins by opening the formatting dialog box. To do this, select the range of cells you want to apply the rule to. For this example, let's assume you have negative numbers in cells B2 to B10.

Once you've selected the cells, click on the "Home" tab in the ribbon, then click on "Conditional Formatting" in the "Styles" group. In the dropdown menu, select "Highlight Cells Rules" and then "Less Than."

Setting Up the Rule

Excel If Value Is Negative Color Red: Conditional!
Excel If Value Is Negative Color Red: Conditional!

In the 'Format Cells that are Less Than' dialog box, type '0' in the 'Value or formula' field. This tells Excel to apply the formatting rule to any cell with a value less than zero, i.e., negative numbers.

Now, click on the 'Format...' button to open the 'Highlight Cells Rules' dialog box. Here, you can choose the fill color for the cells containing negative numbers. In the 'Fill' field, select a color that stands out from the rest of your data. Click 'OK' to apply the fill color.

You'll see that the fill color is now applied to all negative numbers in your selected range. And that's it. You've just learned how to color negative numbers in Excel. Next, let's look at how you can format cells containing text based on their length.

Sum by Colour in Excel in One Click
Sum by Colour in Excel in One Click

Formatting Text Based on Length

Another useful application of conditional formatting is formatting text based on its length. Let's say you have a column of names and you want to highlight long names. To do this, we'll use the "Highlight Cells Rules" option with "Text Length" selected.

How to Change Negative Number into Positive in Excel
How to Change Negative Number into Positive in Excel
How to Make Negative Numbers Red in Google Sheets - ModernSchoolBus.com
How to Make Negative Numbers Red in Google Sheets - ModernSchoolBus.com
Change the Gridline Color in Excel Spreadsheets - 2 Ways!
Change the Gridline Color in Excel Spreadsheets - 2 Ways!
How to Shade or Color Alternate Rows in Excel
How to Shade or Color Alternate Rows in Excel
Sort data by color in Excel
Sort data by color in Excel
How to Sum and Count Negative and Positive Numbers in Excel
How to Sum and Count Negative and Positive Numbers in Excel
Make Negative Numbers Stand Out
Make Negative Numbers Stand Out
Excel Custom Number Format Guide • My Online Training Hub
Excel Custom Number Format Guide • My Online Training Hub
How to split numbers into individual digits in excel
How to split numbers into individual digits in excel
How To Use Excel Fill Color Shortcut: A Quick And Easy Guide
How To Use Excel Fill Color Shortcut: A Quick And Easy Guide
5 Easy Ways to Convert Negative Numbers to Positive in Excel (Step-by-Step Guide) - SmashingApps.com
5 Easy Ways to Convert Negative Numbers to Positive in Excel (Step-by-Step Guide) - SmashingApps.com
an excel spreadsheet showing the number of columns in each column, and how to use them
an excel spreadsheet showing the number of columns in each column, and how to use them
the color coded drop down in excel is shown with an arrow pointing to it
the color coded drop down in excel is shown with an arrow pointing to it
📊 Color Coded Dropdowns in Google Sheets
📊 Color Coded Dropdowns in Google Sheets
Excel Trick: Custom Sort How To do it!
Excel Trick: Custom Sort How To do it!
How To Create Charts and Graphs in Excel
How To Create Charts and Graphs in Excel
the text sum by color in excel is displayed above an image of a computer keyboard
the text sum by color in excel is displayed above an image of a computer keyboard
How to Strip Non-Numeric Characters in Excel
How to Strip Non-Numeric Characters in Excel
2 Ways to Reverse Number Signs Positive Negative in Excel - Excel Campus
2 Ways to Reverse Number Signs Positive Negative in Excel - Excel Campus
Excel's Color Palette Compatibility Solution
Excel's Color Palette Compatibility Solution

Setting the Condition

Select the range of cells with the names (let's assume it's A2 to A10). In the 'Conditional Formatting' dropdown menu, select "Highlight Cells Rules" and then "Text Length."

In the 'Format Cells that Contain ...' dialog box, type the maximum length you consider 'long' in the 'With...' field. For instance, if you consider names longer than 20 characters as long, type '20' in the field.

Choosing the Formatting Style

Click on the 'Format...' button to open the 'Highlight Cells Rules' dialog box. Choose a format that stands out, like a distinctive border or background color. Click 'OK' to apply the formatting style to long names.

Using conditional formatting in Excel opens up numerous possibilities to make your data easier to read and understand. Experiment with different formats and conditions to find the ones that work best for your specific use case. And remember, practice makes perfect. The more you use conditional formatting, the more proficient you'll become.