Condition - Formula is

Applies the selected style to the cell when the formula expression in the text box in the right is not zero. diff --git a/source/text/scalc/01/05120300.xhp b/source/text/scalc/01/05120300.xhp index 7e2327e7bb..451cd09957 100644 --- a/source/text/scalc/01/05120300.xhp +++ b/source/text/scalc/01/05120300.xhp @@ -16,7 +16,6 @@ -

Condition - Date is

Applies the selected style to the cell when the cell contents is formatted as date and the condition is one of the available date interval in the dropdown list. @@ -46,6 +45,5 @@ This year, Last year and Next year: applies the cell style if the cell date contents is in this year, last year and next year respectively. - diff --git a/source/text/scalc/01/05120400.xhp b/source/text/scalc/01/05120400.xhp index c6136ed962..ab288871e2 100644 --- a/source/text/scalc/01/05120400.xhp +++ b/source/text/scalc/01/05120400.xhp @@ -45,35 +45,144 @@

Icon Set

- It is desired to plot the position of a value relative to the thresholds. The set of icons will help to indicate the thresholds and choose the type of icons. Available icon sets are: + Add an icon to the cell based on the value relative to the specified thresholds. Several icon sets are available. +

Available Icon Sets

3, 4 or 5 - arrows + +

Color arrow up +

Color arrow slightly up +

Color arrow same +

Color arrow slightly down +

Color arrow down + 3, 4 or 5 - gray arrows + +

Gray arrow up +

Gray arrow slightly up +

Gray arrow same +

Gray arrow slightly down +

Gray arrow down + 3 - flags + +

Yellow flag +

Red flag +

Green flag + 3 - traffic lights 1 and 2 (two different designs) + +

Yellow traffic light 1 +

Red traffic light 1 +

Green traffic light 1 + + +

Yellow traffic light 2 +

Red traffic light 2 +

Green traffic light 2 + - 3 - symbols (square, triangle, circle) + 3 - Smileys 1 and 2 + +

Yellow positive smiley +

Yellow neutral smiley +

Yellow negative smiley + + +

Green positive smiley +

Yellow neutral smiley +

Red negative smiley + + + + 3 - symbols + +

Shape triangle +

Shape diamond +

Shape circle + + +

Exclamation mark +

Cross +

Check mark + + +

Empty star +

Half star +

Full star + + +

Triangle up +

Same +

Triangle down + 4 - circles from red to black + +

Dark red +

Light red +

Light gray +

Dark gray + 4 or 5 - ratings + +

Empty bars +

One quarters bars +

Half bars +

Three quarters bars +

Full bars + 5 - quarters + +

Empty +

One quarter +

Half +

Three quarters +

Full + + + + 5 - boxes + +

Empty +

One quarter +

Half +

Three quarters +

Full + - Conditions to display each icon can be specified relative to a value (Value), a percentage of the number of values in the range (Percentage) as a percentage of range values (Percentile) or formula (Formula). +

Conditions

+ Conditions to set the thresholds for each icon can be specified as + + + Value: a fixed value. Enter the value in the text box on the left. + + + 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 on the left. 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 the numeric value for the threshold. Values can be numbers, dates or time. Enter the formula expression in the text box on the left. + +

How to use Icon Set Conditional Formatting page in TDF Wiki.

-- cgit