Coloured highlighting in Excel

Aus firesys Hilfe
Version vom 19. November 2021, 12:41 Uhr von K.krautscheid (Diskussion | Beiträge)
(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)
Zur Navigation springen Zur Suche springen

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


EN Menüband Excel Status Information Markierung.jpg



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.


Glühbirne neu.png
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.


Excel Status Markierungen Fehlerzellen.jpg


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.


Excel Status Markierungen Validierungen.jpg


Glühbirne neu.png
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.


Excel Status Markierung Wörterbuchzellen.jpg


Glühbirne neu.png
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.


Excel Status Markierung Formelzellen.jpg


Master value cells

Checks existing cells with master values on all worksheets and highlights them by underlining.

Excel Status Markierung Zentralwerte.jpg


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

Navigation hoch.svg The worksheet status in Excel
Navigation rechts.svg The StatusCockpit
Navigation rechts.svg The worksheet inspector
Navigation rechts.svg The worksheet navigator
Navigation rechts.svg The worksheet status
Navigation rechts.svg The rolling forward function

Further contents

firesys website
Customer area
YouTube