Coloured highlighting in Excel
Here you see an overview of the content-related structure of your Excel data by using coloured highlighting.
Set highlighting
When working in Excel with firesys, you can fill the cells in your document with content in different ways. To give you a quick overview of which cells contain not just pure text or manually entered numerical values without special functions (validations, for example), you can automatically set coloured highlighting for some cell types.
If you have selected several highlights that should be displayed, then only one coloured highlighting is ever displayed (even if an Excel cell meets the conditions that several highlights could be displayed). The prioritisation here is identical to the sequence listed below and the sequence of the buttons in the drop-down menu.
Good to know
| |
---|---|
As soon as one or more highlighting has been set, the relevant highlighting type is used throughout the document. If you add more worksheets or change the structure of the existing worksheets, then the highlighting is applied the next time the document is opened or the relevant highlighting is also set to the new document areas. |
Error cells
Highlights all cells containing Excel errors in magenta. This displays #WERT! / #DIV/0! / #NAME? / #BEZUG! / #NULL! and #ZAHL! errors.
Validation cells
Highlights all cells that are part of a validation with a green or red background. All error-free validations are highlighted in green and all validations where there is a deviation are highlighted in red. Green highlighting is also applied to validations whose deviation was approved beforehand.
Good to know
| |
---|---|
The highlighting of validations respond dynamically with a colour change. For example, a validation that was previously error-free and highlighted in green is immediately highlighted in red if a deviation occurs during editing. |
Dictionary cells
Highlights all cells that are linked to the firesys dictionary in light blue.
Good to know
| |
---|---|
By the internal formula of dictionary cells, these are also highlighted if the formula cells can be highlighted in colour. |
Formula cells
Highlights all cells that contain an invisible formula in grey.
Master value cells
Checks existing cells with master values on all worksheets and highlights them by underlining.
Remove highlight
Removes the highlighting of the cells that are highlighted in colour. You can select whether individual or all highlighting types should be removed.
See also
The worksheet status in Excel
The StatusCockpit
The worksheet inspector
The worksheet navigator
The worksheet status
The rolling forward function