Home Work How to Make Negative Numbers Red in Google Sheets

How to Make Negative Numbers Red in Google Sheets

by Frank
Published: Last Updated on

Introduction

When using Google Sheets to handle financials, you’re certain to come into values that are less than zero. You can make those negative numbers stand out by making them appear in red, which is considerably clearer than a minus sign or parenthesis.

This may be accomplished in one of two ways. You may rapidly apply some custom format settings. If you want greater control, try using a conditional formatting rule.

Using a Custom Format, Color Negative Numbers Red

You may add a red color to a range of cells in Google Sheets by using a custom number format. Only negative numbers will be highlighted in red.

Open your spreadsheet in Google Sheets after signing in if required. Choose the cells that contain or may contain negative numbers.

Selected range of cells

Navigate to the Format tab, then to Number, and finally to “Custom Number Format.”

Select Custom Number Format

Type “red” into the box at the top of the window that displays. You’ll next be presented with a selection of number formats from which to pick. You may click on each one to get a sample of how it will look. The negative figures are shown in parenthesis with red text in these selections.

When you’ve found the one you’re looking for, click “Apply.”

Negative number formats

Your chosen cells will then be updated to reflect the new format for negative values. When you modify a value to a positive integer, the custom format changes to remove the parenthesis and red font.

Selected cells formatted

Use Conditional Formatting to make Negative Numbers Red

You may use conditional formatting to change the typeface for negative integers to red without changing the format.

Choose the cell range, then go to the Format tab and choose “Conditional Formatting.” This brings up the right-hand sidebar where you may build your rule.

Select Conditional Formatting

Select the Single Color tab at the top and confirm the cells you’ve chosen in the Apply To Range box. If you choose, you may optionally provide an extra range of cells.

Confirm the cell range

Open the Format Cells If drop-down box in the Format Rules section and pick “Less Than.” Enter a zero in the box just underneath.

Select Less Than and enter zero

Open the Fill Color palette in the Formatting Style box and choose “None.” Then, open the Text Color palette and choose a red tone. Click the “Done” button.

Choose the red font

Your chosen cells will be updated to show negative integers in red while retaining the format you use to identify negative numbers.

Selected cells formatted

If you want to make negative numbers in Google Sheets red, these two simple methods will allow you to set it up and then automatically turn them red as necessary.

You may also like

Navhow is dedicated to teaching people all over the world how to do anything.

 

Subscribe

The Best How-To Newsletter Anywhere

©2022 Navhow, All Right Reserved