# 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.

Por atingi ĉi tiun komandon...

Choose Format - Conditional - Color Scale

#### From the tabbed interface:

Choose Home - Conditional - Color Scale.

Color Scale

### Conditions

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

• Min (Max): calculates using the minimum (maximum) values in the range.

• Value: a fixed value. Enter the value in the text box.

• Percentile: A percentile is each of the 99 values which divide the sorted data in 100 equal parts, so that each part represents 1/100 of the sample population. A percentile return the value for a data series going from the smallest to the largest value in a set of data. For P = 25, the percentile means the first quartile. P = 50 is also the MEDIAN of the data set. Enter the percentile value in the text box. Valid values are from 0 to 100.

• Percent: a fixed value representing the percentage of the minimum (maximum) of the length defined by minimum and maximum values in the range. A minimum of 10% selects the values below 10% of the segment [Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max]. Valid values are from 0 (zero) to 100. Do not enter a percent (%) sign.

• Formula: A formula expression starting with the equal sign (=) that calculates a numeric value. Values can be numbers, dates or time. Enter the formula expression in the text box.

## Data Bar

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

Por atingi ĉi tiun komandon...

Choose Format - Conditional - Data Bar

#### From the tabbed interface:

Choose Home - Conditional - Data Bar.

Data Bar

### Conditions

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

• Automatic: calculates using the minimum and maximum values in the range.

• Min (Max): calculates using the minimum (maximum) values in the range.

• Value: a fixed value. Enter the value in the text box.

• Percentile: A percentile is each of the 99 values which divide the sorted data in 100 equal parts, so that each part represents 1/100 of the sample population. A percentile return the value for a data series going from the smallest to the largest value in a set of data. For P = 25, the percentile means the first quartile. P = 50 is also the MEDIAN of the data set. Enter the percentile value in the text box. Valid values are from 0 to 100.

• Percent: a fixed value representing the percentage of the minimum (maximum) of the length defined by minimum and maximum values in the range. A minimum of 10% selects the values below 10% of the segment [Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max]. Valid values are from 0 (zero) to 100. Do not enter a percent (%) sign.

• Formula: A formula expression starting with the equal sign (=) that calculates a numeric value. Values can be numbers, dates or time. Enter the formula expression in the text box.

### 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

• Gradient: set a color scale between the color of positive (negative) values and white.

• Color: use the positive (negative) color for the entire data bar, no fade out gradient.

#### Axis

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

• Automatic: position the vertical axis in the middle of the maximum and minimum values.

• Middle: set the vertical axis in the middle of the column.

• None: do not display a vertical axis.

#### 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.

## Icon Set

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

Por atingi ĉi tiun komandon...

Choose Format - Conditional - Icon Set

#### From the tabbed interface:

Choose Home - Conditional - Icon Set.

Icon Set

### Available Icon Sets

• 3, 4 or 5 - arrows

• 3, 4 or 5 - gray arrows

• 3 - flags

• 3 - traffic lights 1 and 2 (two different designs)

• 3 - Smileys 1 and 2

• 3 - symbols

• 4 - circles from red to black

• 4 or 5 - ratings

• 5 - quarters

• 5 - boxes

### Conditions for thresholds

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

• Value: a fixed value. Enter the value in the text box.

• Percentile: A percentile is each of the 99 values which divide the sorted data in 100 equal parts, so that each part represents 1/100 of the sample population. A percentile return the value for a data series going from the smallest to the largest value in a set of data. For P = 25, the percentile means the first quartile. P = 50 is also the MEDIAN of the data set. Enter the percentile value in the text box. Valid values are from 0 to 100.

• Percent: a fixed value representing the percentage of the minimum (maximum) of the length defined by minimum and maximum values in the range. A minimum of 10% selects the values below 10% of the segment [Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max]. Valid values are from 0 (zero) to 100. Do not enter a percent (%) sign.

• Formula: A formula expression starting with the equal sign (=) that calculates a numeric value. Values can be numbers, dates or time. Enter the formula expression in the text box.

### Malfermi dosieron kun ekzemplo:

Bonvolu subteni nin!