# How To Highlight Negative Numbers Red in Google Sheets? (3 Easy Methods)

When you are working with a numerical dataset, it is quite common to experience negative numbers. If your dataset is small, then it’s very easy to identify the negative numbers to understand the detailed analysis of the data. However, if you are working with a large dataset, then manually checking the negative numbers would be difficult. And hence, to help with the problem, Google Sheets allows its users to highlight the negative numbers in the desired color.

For example, let us assume that you are working with November sales data and you want to compare the current sales month data with the previous month’s to know where you have performed well and where you haven’t. If you have 10 rows of data, then you can quickly analyze the results. However, if your dataset is quite large, then manually drawing the conclusion would be difficult. To help you overcome this issue, here is a detailed page that teaches you how to highlight the negative number in red using the Google Sheets Tips. Scroll down to find out more.

## How to Make Negative Numbers Red in Google Sheets?

There are various methods with the help of which we can highlight the negative numbers in red. One of the easiest methods to highlight the negative numbers in red is by using the Custom number format. The detailed steps on how to change negative numbers into red using the custom number format are explained below.

• 2nd Step: Select the dataset and click on the “Format” tab.
• 3rd Step: Choose “Number” and select “Custom number format” towards the bottom of the drop-down list.

• 4th Step: Now paste the formula “#,##0; [Red](#,##0)” in the Custom number format box.

• 5th Step: Press the “Apply” button and you will see the negative numbers being highlighted in red.

Apart from the above formula, one can also use the following formulas in the Custom number format box to get the same results:

• #,##0;[Red]#,##0
• #,##0;-[red]#,##0

### Using Conditional Formatting To Show Negative Numbers As Red in Google Sheets

Google Sheets also allows its users to change the negative numbers into red using the Conditional Formatting option. The detailed steps on how to get this done in the spreadsheet are outlined below:

• 2nd Step: Now on the homepage, select the dataset which needs to be highlighted in red.
• 3rd Step: Click on the “Format” tab and choose “Conditional Formatting” from the drop-down menu.

• 4th Step: The Conditional Formatting menu opens on the screen. Now cross-check the cell range under the “Apply to Cell Range” box.
• 5th Step: Under the “Format Rules” tab, choose the “Less than” option.
• 6th Step: In the “Value or Formula” box, enter the number Zero.
• 7th Step: In the “Formatting Style“, click on the Text Color and choose the color “Red” to highlight the data in red. If you also want to highlight the cell in red, then choose “Red” color from the Fill Color.
• 8th Step: Press the “Done” button and you will see the results as shown in the image given below.

### Using Apps Scripts to Change Negative Numbers to Red

Apart from the above-listed steps, one can also use Apps Scripts to highlight the negative numbers in red. The steps to do this in the Google Sheets are given below: