The Number tab of the Format Cells… dialog allows end-users to apply a number format to display cell numbers as monetary values, percentage values, date values, etc. (For an example on how to create a Ribbon UI, refer to the Getting Started document.) Number Tab To do this, provide the Home Ribbon page for the SpreadsheetControl. You can also allow end-users to invoke the Format Cells… dialog via the Ribbon UI. The dialog box includes six tabs: Number Alignment Font Border Fill and ProtectionĮnd-users can invoke this dialog by right-clicking a cell and selecting the Format Cells… item from the context menu. In the end, click OK and you will get the negative numbers highlighted in red color.The Format Cells dialog allows end-users to format data in a worksheet (specify cell background, font color and style, change content alignment, apply cell borders, etc.).Now, select the “Number” tab and under the “Category” select the “Number” option and then select the last red negative option.Once you click on the dialog box launcher, you will get the “Format Cells” window opened.First, select the cells or range with the numbers and go to the “Home” tab and then click on the dialog box launcher of the “Number” group.

Make Negative Numbers Red Using Number Format

To change the formatting color, select the right-side drop-down icon and select the color of your choice and click OK.

Now, enter 0 (Zero) under the “Format cells that are Less Than” field and you will get the negative numbers highlighted in red color.

Once you select the “Less Than” option, you will get the “Less Than” window opened.

After that, click the “Highlight Cells Rules” option and then select the “Less Than” option from the list.

First, select the cells or range with the numbers and go to the “Home” tab and click on the “Conditional Formatting” drop-down icon.

Make Negative Numbers Red Using Conditional Formatting We have mentioned some quick and effortless steps for you to make negative numbers red in Excel. So, it becomes important to highlight the negative numbers in red so that anyone can find and read them easily and quickly.Įxcel has the option to highlight the negative numbers in red or any other color of your choice and this is a very quick process and takes less than a minute or two. In Excel, while working with large data sets or with a long set of numbers, it becomes difficult for anyone to find out the negative numbers easily and quickly.

Excel number format dialog box launcher