If Syntax highlighting is enabled, all cell contents will be color-coded according to their content. For example, cells containing an error are displayed in red; cells containing a formula are displayed in green, etc.
This allows you to see at a glance where formulas are located and where fixed values are entered, where errors occur, etc.
Enabling and disabling syntax highlighting
To enable syntax highlighting, choose the ribbon command View | Syntax highlighting 
(in the group View).
If you choose this command again, it will be disabled.
Meaning of foreground color
When syntax highlighting is enabled, cell contents are displayed in the following foreground colors:
Cell content |
Foreground color |
Error value |
Red |
Formula |
Green |
Fixed positive number |
Navy |
Fixed negative number |
Light blue |
Fixed logical value |
Brown |
Fixed text string |
Black |
Meaning of background color
Cells that contain an error are thus displayed in a red foreground color. In the event of serious errors, the cell is also given a colored background. The background color indicates the error type:
Background color |
Error type |
White |
The formula returns an error value. The calculation in this cell returns an error value because, for example, it contains a division by zero. |
|
Tip: If you click on the cell, an error message will be displayed in the status bar. For more information, see Error values. Correct the formula accordingly. |
Cyan |
Syntax error in the formula. The formula in this cell is incorrectly formulated because, for example, a closing parenthesis is missing or a function was not called with the correct arguments. |
|
Tip: If you click on the cell, an error message will be displayed in the status bar. Correct the formula accordingly. If you don't correct the formula, it will be replaced by the text string #NULL! when the document is saved! |
Light gray |
Non-exportable function. The formula in this cell uses an arithmetic function that cannot be saved in the file format in which you saved the document. |
|
Tip: Replace the function with another function that is compatible with the desired file format. For more information, see the corresponding function description in this manual. |
Magenta |
Function possibly imported incorrectly. The formula in this cell uses an older PlanMaker arithmetic function whose syntax or function might be incompatible with recent versions of PlanMaker. This error only occurs when importing PlanMaker documents with time functions. |
|
Tip: See the corresponding function description in this manual. |
Yellow |
Unknown function. The formula in this cell uses an arithmetic function unknown to PlanMaker. This error might occur when importing documents created with other applications (e.g. Microsoft Excel). |
|
Tip: Replace the function with a corresponding PlanMaker function. For a list of all PlanMaker functions, see Functions from A to Z. |