Step 1: Select all the data from your cells as shown below: Now we will see how to represent the negative numbers with the built-in number formatting in Excel. Where all the negative numbers are colored as Red and cells are colored as light red.Įxample #2 – Negative numbers with Built-in Number Formatting
In that box, Put the value as zero (0) within the box under Format cells that are Less Than and select appropriate cells as well as text color through the dropdown menu on the right.Ĭlick the OK button, and you can see the result as below. Step 4: A new dialog box Less Than opens up.
