Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the rocket domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/practical-tips.com/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the soledad domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/practical-tips.com/wp-includes/functions.php on line 6114
Excel: Mark negative numbers red & positive ones green - Practical Tips

Excel: Mark negative numbers red & positive ones green

by Johannes

In Excel, you can color a negative number red if needed. To make this work, you need to know a few important things

Excel: How to mark negative numbers red

Open the Excel document in which you want to mark the negative numbers red. Then proceed as follows:

  • Mark the numbers that should be colored red. Then go to “Start” ☻ Conditional Formatting ☻ New Rule”.
  • In the new window, select “Format only cells that contain”. For “Format only cells containing”, choose “cell value” as well as “less than”. In the right row select “0”. Confirm with “Format”.
  • Go to “Color” and select the red color here. Confirm with “OK”.
  • The marked numbers in the table will now be displayed in red color. To color other numbers green, repeat the whole process, but select the green color in the last step.

Related Articles

Leave a Comment