Value Highlighting

Displays cell content in different colours, depending on type.

To remove the highlighting, unmark the menu entry.

To access this command...

From the menu bar:

Choose View - Value Highlighting.

From the tabbed interface:

Choose View - Value Highlighting

On the View menu of the View tab, choose Value Highlighting.

Icon Value Highlighting

Value Highlighting

From the keyboard:

+ F8

By default:

Text cells are formatted in black, formulae in green, number cells in blue, and protected cells are shown with light grey background, no matter how their display is formatted.

These colours can be customised in - LibreOffice - Application Colours.


If this function is active, colours that you define in the document will not be displayed. When you deactivate the function, the user-defined colours are displayed again.

Please support us!