Openoffice conditional formatting by cell containing

Select the Diverging check box to also specify a Center value and color.ДЄn example table with color scale background formatting on the Affordability column looks like this: Drop down and select the colors swatches you want to apply to the minimum and maximum values. Under Minimum and Maximum, choose whether to apply the color scheme based on the lowest and highest field values, or on custom values you enter. Under Default formatting, select a formatting to apply to blank values. Under Summarization, specify the aggregation type you want to use for the selected field. You can base the formatting on the current field, or on any field in your model that has numerical or color data.

Under Based on field, select the field to base the formatting on. To format cell background or font color by color scale, in the Format by field of the Background color or Font color dialog box, select Color scale. If you make a field's font and background the same color, the font blends into the background so the table column shows only the colors. You can apply the same or different conditional formatting to a field's font color and background color. The Background color and Font color options are the same, but affect the cell background color and font color, respectively. After selecting conditional formatting options, select OK. The Background color or Font color dialog box opens, with the name of the field you're formatting in the title. To format cell background or font color, select Conditional formatting for a field, and then select either Background color or Font color from the drop-down menu. You can combine more than one option in a single table column. The following sections describe each conditional formatting option. To remove conditional formatting from a visualization, select Remove conditional formatting from the field's drop-down menu, and then select the type of formatting to remove. Conditional formatting overrides any custom background or font color you apply to the conditionally formatted cell.

Openoffice conditional formatting by cell containing