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

Which is Best Settings for Warzone – Optimize Your Performance – 4 Steps

Discover the Best settings for Warzone to achieve better performance and precision. See how to…

20 hours ago

Top 10 Best Hunty Zombie Code – Complete Details

We have put together a list of the Top 10 Best Hunty Zombie Code options…

20 hours ago

Which is the Best OS for Mobile? Complete Details – Top 3 Options

Explore the Best OS for Mobile as we look at Android, iOS, and also those…

2 days ago

Where Do FaceTime Photos Go? Understanding Their Storage Location – Top 3 Ways to Manage

This guide will take you through where do FaceTime photos go on your iPhone or…

2 days ago

Windows 12 Release Date – What to Expect – Complete Details

Discover the Windows 12 release Date, which is expected to be between 2025 and 2026.…

2 days ago

How to Check Apple Serial Number On All Apple Products – 4 Main Devices

This guide will walk you through the process of how to check Apple serial number…

2 days ago

This website uses cookies.