Conditional formattings

The following conditional formattings exist:

Comparison settings

The comparison settings specify that a cell is to be displayed with a defined font color and/or background color if the condition is met.

Comparison settings

Data bar settings

In the data bar settings, you can set the size at which a color bar is displayed in a cell. The result is similar to a bar chart.

Data bar settings

Highlight settings

In the highlight settings you specify the extent to which a cell should be colored with a defined background color.

Highlight settings