Featured Article

Mastering Excel: Differentiate Positive & Negative Numbers with Color Coding

Russell Aug 07, 2026

Working with numbers in Excel often involves analyzing both positive and negative values. To make your data more understandable and easier to work with, you can color code these values. Here's a step-by-step guide on how to do this.

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

By applying conditional formatting in Excel, you can quickly and easily change the appearance of cells based on their contents. In this case, we'll use it to color code positive and negative numbers. Let's dive into the process.

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

Color Coding Positive Numbers

To distinguish positive numbers from others, let's first focus on giving them a distinct color.

Color Coded Drop-Down Lists in Excel‼️ #excel
Color Coded Drop-Down Lists in Excel‼️ #excel

Here's how you can do this:

Using Fill Color

the color code is shown in this screenshot
the color code is shown in this screenshot

One of the simplest ways to color code positive numbers is to fill the cells containing them with a specific color.

1. Select the cells containing the positive numbers you want to color. 2. Click on the 'Fill Color' icon in the 'Home' tab. 3. Choose the color you prefer to use for positive numbers from the palette or use the 'More Colors' option to select a specific color.

Using Conditional Formatting

Make Negative Numbers Stand Out
Make Negative Numbers Stand Out

For more complex color coding, you can use conditional formatting to apply a rule that will fill positive numbers with a specific color.

Step 1: Select the data range you want to apply the formatting to.

Step 2: Click on the 'Conditional Formatting' button in the 'Home' tab, then select 'Highlighter Rules' and 'Equal to...'.

Excel Custom Number Format Guide • My Online Training Hub
Excel Custom Number Format Guide • My Online Training Hub

Step 3: Enter '0' in the 'Value or formula to test' box. This will select all cells with a positive value greater than zero.

Step 4: Choose the fill color you want to apply from the 'Fill' section.

How to Change Legend Colors in Excel (3 Steps)
How to Change Legend Colors in Excel (3 Steps)
excel create color - coded drop - down menu
excel create color - coded drop - down menu
Hex codes
Hex codes
Color Coding Data in Excel: Inputs vs. Formulas
Color Coding Data in Excel: Inputs vs. Formulas
How To Use Excel Fill Color Shortcut: A Quick And Easy Guide
How To Use Excel Fill Color Shortcut: A Quick And Easy Guide
How to Sum Positive Number |sum positive numbers | Excel Tutorials | excel Tutorials
How to Sum Positive Number |sum positive numbers | Excel Tutorials | excel Tutorials
Top 21 Excel Formulas
Top 21 Excel Formulas
Colours 🤍🖤
Colours 🤍🖤
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 Make Negative Numbers Red in Google Sheets - ModernSchoolBus.com
How to Make Negative Numbers Red in Google Sheets - ModernSchoolBus.com
the font and numbers in different colors are displayed on an iphone screen, with text below them
the font and numbers in different colors are displayed on an iphone screen, with text below them
color hex code
color hex code
an iphone screen showing the font and numbers in different colors
an iphone screen showing the font and numbers in different colors
Colour codes✨️❤️
Colour codes✨️❤️
an excel chart with the text boss how did you create dropdowns?
an excel chart with the text boss how did you create dropdowns?
the color chart for different types of colors in each section, including pink, yellow and blue
the color chart for different types of colors in each section, including pink, yellow and blue
the font and numbers are all different colors in this screen shot, but there is no image
the font and numbers are all different colors in this screen shot, but there is no image
codes couleurs
codes couleurs
Excel Formulas You Should Know
Excel Formulas You Should Know
the color chart for good notes hex code
the color chart for good notes hex code

Step 5: Click 'OK' to apply the formatting.

Color Coding Negative Numbers

Similarly, you can apply a different color to highlight negative numbers.

Here's how you can do this:

Using Fill Color

Using the same process as color coding positive numbers, you can select the fill color for negative numbers:

1. Select the cells containing the negative numbers. 2. Click on the 'Fill Color' icon and choose the color you want to use for negative numbers.

Using Conditional Formatting

If you want more control over your color coding, you can use conditional formatting to set a rule for negative numbers.

Step 1: Select the data range.

Step 2: Click on 'Conditional Formatting', then 'New Rule...'.

Step 3: Select 'Format only cells that contain...', then 'less than...'.

Step 4: Enter '0' in the 'Value or formula to test' box. This will select all cells with a negative value.

Step 5: Choose the color you want to use for negative numbers from the 'Fill' section.

Step 6: Click 'OK' to apply the formatting.

Now you have successfully color-coded your positive and negative numbers in Excel. This can greatly enhance the readability of your data and make it easier to identify trends and outliers. Keep experimenting with different formats and rules to find what works best for your specific use case.

Happy data analyzing!