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.

To access this command...

From the menu bar:

Choose Format - Conditional - Color Scale

From the tabbed interface:

Choose Home - Conditional - Color Scale.

From toolbars:

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 fills the cell with solid or gradient color corresponding to the numeric value in the cell.

To access this command...

From the menu bar:

Choose Format - Conditional - Data Bar

From the tabbed interface:

Choose Home - Conditional - Data Bar.

From toolbars:

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.

To access this command...

From the menu bar:

Choose Format - Conditional - Icon Set

From the tabbed interface:

Choose Home - Conditional - Icon Set.

From toolbars:

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:

Please support us!