Categories: HOMEHOW TO

How to Make Negative Numbers Red in Google Sheets – Top 3 Methods

You can make negative numbers red in Google Sheets easily. I have shared three different ways to make any type of – negative number in Red color or even in any other different color.

Negative numbers are those that are less than zero, and Excel automatically prefixes them with a minus symbol. If you use Google Sheets to keep tabs on your finances, you’re bound to come across some negative statistics. To make negative numbers more visible, you can have them show in red automatically, which is considerably more visible than a minus sign or parenthesis.

How to Make Negative Numbers Red in Google Sheets

The three approaches to make negative numbers red in Google sheets are:

  1. Using Conditional Formatting
  2. Using Custom Formatting
  3. Using number Formatting

Assume you have the following dataset.

Read more: How to Make a Gantt Chart in Google Sheets

Method 1. Using conditional Formatting

You can format a cell based on its contents using conditional formatting. With conditional formatting, it is possible to change the font color of negative numbers without changing the format.

To make negative numbers red in Google Sheets, follow these simple steps:

  1. Choose the cell range that you want to use.
  2. Select the Format menu option.
  3. And choose “Conditional Formatting.”
  4. At the top, click the Single Color tab and verify the cells chosen in the Apply To Range box.
  5. Select the ”Format cells if” option.
  6. Select the ”Less than” option from the drop-down menu.
  7. Input 0 in the ”Value or Formula” section.
  8. Now, set the cell’s highlight color.
  9. Then click on Done.
  10. All cells with a value less than 0 would be immediately displayed by the above steps.
    If the cell value changes, the formatting in the cell is instantly updated since conditional formatting is dynamic.

Read more: How to Create a Graph in Google Sheets

Method 2. Using Custom Formatting

Using a custom number format in Google Sheets, you can turn a range of cells red. This will highlight only negative numbers.

  1. Go to Google Sheets, login in if necessary, and open the spreadsheet that you created.
  2. Pick the cells which have or may have negative numbers.
  3. In the menu, choose the Format tab.
  4. Now, select “Custom Number Format” from the Number drop-down menu on the Format tab.
  5. Fill out the next box to choose how you want your numbers formatted: #,##0.00_);[Red](#,##0.00).
  6. Select the Apply option.

Now, despite everything else in your dataset remaining the same, the negative numbers would be highlighted in red.

Read more: How to Make a Spreadsheet in Google Docs

You can also choose from many number formats if you use custom number formatting:

  • Positive numbers
  • Negative numbers
  • Zero values
  • Text values

Read more: How to Group Worksheets in Excel

Method 3. Using Number Formatting

  1. Select cell range and datasheet.
  2. Go to Excel’s Home tab and select the little arrow-shaped icon to expand the Number group’s numerical formatting.
  3. In this section, you can format cells and change the cell’s formatting to suit your needs. From the drop-down menu on the window’s left side, choose “Number” or “Currency.”Choose negative numbers (1234.10) and press the OK tab.
  4. When you return, you’ll find a red mark on a negative number.

Read more: How to Make a Timeline on Google Docs

Conclusion

Conditional Formatting should be used with caution when displaying negative numbers since it reassesses its condition and applies to format again if the number changes. You can even change the colour of the text using custom formatting. However, Text formatting does not support colours.

A variety of colors are available, including black, red, blue, yellow, and green. So, I’ve listed 3 ways to make cell values with negative values stand out in red. I prefer to format negative numbers using custom formatting instead of using built-in functions in most programs.

Was this article helpful?
YesNo

This post was last modified on February 9, 2022 00:07

Ekaant Puri

I love to write about the latest technology. My work is to write on HowTo, Top 10 and tech solving topics.

Recent Posts

Difference Between Apple Watch Aluminum vs Titanium – Complete Details

In this article, we will look into these differences, which in turn will help you…

18 hours ago

How to Change Voice on Apple Maps Easily – Best 6 Steps

In this guide we will take you through step by step how to change voice…

19 hours ago

How to Activate Apple Card – Best 4 Methods

In this guide, we will take you through the 4 different ways to activate Apple…

2 days ago

Difference Between Apple Music vs YouTube Music – Which One Should You Choose?

In this article, we will look at the differences between Apple Music vs YouTube Music,…

2 days ago

Difference Between AirPod Pro 1 vs 2 – Complete Details

In this article, we will look at in detail the differences between the AirPod Pro…

3 days ago

Top Ways to Fix Apple Watch Not Tracking Activity Issue – 9 Best Methods

In this, we will discuss the Top Ways to Fix Apple Watch Not Tracking Activity.…

3 days ago

This website uses cookies.