Condition - All cells

Applies the conditional formatting to the set of cells defined in the selected range. The formatting is applied based on the contents of the whole range.

Color Scale

Applies a color scale to a range consisting of displaying a bicolor or tricolor gradient on this range depending on the value of each cell.

Så här använder du det här kommandot...

Choose Format - Conditional - Color Scale

On the Formatting bar, click

Icon Color Scale

Color Scale


Conditions

The calculation of the color scale depends on 2 or 3 conditions, defined as follows:

Open file with example:

Data Bar

Data bar option will fill the cell with solid or gradient color corresponding to the numeric value in the cell.

Så här använder du det här kommandot...

Choose Format - Conditional - Data Bar

On the Formatting bar, click

Icon Data Bar

Data Bar


Conditions

The calculation of the bar area fill is based on the conditions below:

More Options

The Data Bar dialog opens to add details on the display of data bars.

Entry values

Same as the conditions above.

Bar Colors

Choose the color for positive and negative values.

Fill

Axis

Set the position of the vertical axis for the data bar. Values are

Bar Lengths

Sets the minimum (maximum) length of the data bars, as a percentage of the column width.

Display bars only

Do not display values in the cell, only the data bars.

Open file with example:

Icon Set

Add an icon to the cell based on the value relative to the specified thresholds. Several icon sets are available.

Så här använder du det här kommandot...

Choose Format - Conditional - Icon Set

On the Formatting bar, click

Icon Icon Set

Icon Set


Available Icon Sets

Conditions for thresholds

Conditions to set the thresholds for each icon can be specified as follows

Open file with example:

Stötta oss!