HomeWindowsOpenOffice.org Calc: Highlight Negative Numbers in Red

OpenOffice.org Calc: Highlight Negative Numbers in Red

When analyzing your spreadsheet, especially if it contains financial data, it can be quite helpful to have negative numbers standout as a different color from the positive ones. This makes it much easier to find problem areas. To do this:


1. Select the range of cells.

2. Click Format and select Cells.

3. Select the Numbers tab.

4. In the Options section, check the Negative numbers red checkbox.

5. Click OK.

All negative numbers within the range will now be displayed in red.

Red may not be your color of choice, if that’s the case, you can use a different color by following these steps:

1. Select the range of cells.

2. Click Format and select Cells.

3. Select the Numbers tab.

4. In the Options section, check the Negative numbers red checkbox.

5. In the Format code text box, you will notice some code (for example [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00 or 0;[RED]-0).

6. Change the word RED to a different color, such as BLUE or GREEN.

7. Click the add icon (the button with the check mark).

8. If the new format appears in the Format list, you are good to go. However, if it does not, try another color.

9. Select the new format in the Format list..

10. Click OK.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

1 COMMENT

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android