Value Highlighting

Displays cell contents in different colors, 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, formulas in green, number cells in blue, and protected cells are shown with light grey background, no matter how their display is formatted.

These colors can be customized in - LibreOffice - Application Colors.


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

Please support us!