In this post, we will help you show negative numbers in red color in a Google Sheets document. This will come in handy when you have a dataset with values less than 0 in different cells and you want to highlight them at once to identify those values easily. The color of other values (having data 0 or greater than 0) will not change. Apart from that, whenever you will update the values (say changing the data from less than 0 to a positive value) in those cells, the color will change automatically.
Show Negative numbers in Red color in Google Sheets document
There are two different ways to highlight negative numbers in red color in a Google Sheets document. These are:
- Using Conditional Formatting
- Using Custom Formatting.
Let’s check both the options one by one.
1] Highlight negative numbers in red color in a Google Sheets document using Conditional Formatting
The conditional formatting option highlights the entire cell with red color that has negative numbers. You can also choose a custom color of your choice to highlight negative numbers. Let’s check the steps:
- Open a Google Sheets document that contains your dataset
- Select the cells having the negative numbers
- Access the Format menu
- Click on the Conditional formatting option. It will open the Conditional format rules box on the right-hand section
- Click on the drop-down menu available for Format cells if… section
- Select the Less than option from that drop-down menu
- Enter 0 in the Value or formula box
- Click on the Fill color icon to open the color palette
- Select Red color from the palette. You can also choose some other color of your choice
- Press the Done button.
That’s it. Now you will notice that all the negative value cells selected by you are highlighted with the red color or the color chosen by you. As you change the values in the selected cells, the color will be changed accordingly because of the rule set by you.
Also read: How to change Date format in Google Sheets and Excel online.
2] Show negative numbers in red color in a Google Sheets document using Custom Formatting
Using custom formatting, the color of selected cells is not changed, only the value color present in the selected cells is changed in red color. You can’t set a custom color to highlight negative numbers, only red color is there. Here are the steps:
- Open your Google Sheets document that has your dataset
- Select the cells that include negative numbers
- Click on the Format menu of your Google Sheets document
- Access the Number option
- Click on the Custom number format option present on the bottom part. Custom number formats box will pop-up
- In the Custom number format field, paste
- Click on the Apply button.
This will immediately highlight negative values with red color in the cells selected by you. Whenever you will change the values in the cells where you have applied the custom formatting, the color for negative values in those cells will change automatically.
How do you highlight negative numbers in red?
If you want to highlight the negative numbers in red in a Google Sheets document, then there are two ways for doing this. You can use the conditional formatting and custom formatting options present under the Format menu of your Google Sheets document. While the first option lets you fill or highlight the selected cells (having negative numbers) with red color or a custom color, the latter option lets you highlight negative values in selected cells with red color only. We have already covered both the options separately with a step-by-step guide in this post above.
How do I color numbers in Google Sheets?
You can use the conditional formatting option available under the Format menu of a Google Sheets document to highlight or color cells for the numbers or values. For example, you can set a rule that if the value present in the selected cell(s) is greater than 10, then that cell will be filled or highlighted with the green color or some other color of your choice.
Hope it is helpful for you.
Read next: How to add an image in Google Sheets.