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.
0 Comments
Leave a Reply. |