![]() The above steps would instantly highlight all the cells where the value in it is less than 0. Set the color in which you want to highlight the cell.Click on the ‘Less than’ option (you may have to scroll down a bit to see this).Click on the ‘Format cells if’ drop-down.This will open the ‘Conditional formatting rules’ pane on the right Select the cells in which you want to highlight the negative numbers.Suppose you have a dataset as shown below:Īs you can see, it takes some effort if going through the numbers and spotting the ones that are negative.īelow are the steps to show negative numbers in red in Google Sheets: Since we want to highlight all the negative values, we can use conditional formatting to only show negative values in red and leave everything as is. So let’s get started! Show Negative Numbers in Red – Using Conditional FormattingĬonditional formatting allows you to format a cell based on the value in it. ![]() Show Negative Numbers in Red – Using Custom Formatting.Show Negative Numbers in Red – Using Conditional Formatting.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |