Coloured highlighting in Excel

Here you see an overview of the content-related structure of your Excel data by using coloured highlighting.

TBD <imagemap>Datei:Excel_Status_Menüband-Vorrollen.jpg|1200px|center rect 3 85 219 203 Die_Basisfunktionen_von_firesys rect 224 85 511 202 Das_StatusCockpit rect 515 85 593 201 Der_Blatt-Inspektor rect 597 86 721 202 Farbige_Markierungen_in_Excel rect 725 86 800 200 Der_Blatt-Navigator rect 802 85 885 200 Der_Blattstatus rect 890 83 1108 201 Die_Vorrollen-Funktion

desc none </imagemap>

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. TBD

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.

Formula cells

Highlights all cells that contain an invisible formula in grey.

	Good to know
	By the internal formula of dictionary cells, these are also highlighted if the formula cells can be highlighted in colour.

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 in Excel
The rolling forward function

Further contents

→ firesys website
→ Customer area
→ YouTube