Select the built-in Increment list or Palettes.įlip the order of colors for From' and To or in the selected palette. This is available only when Load Palette is selected.
Use it to specify the color for the middle level. This is available only when 3-Color Limited Mixing is selected. Use it to specify the color for the minimum level.
Click the Select Palette button, you can select one palette from the built-in Increment list or Palettes. Load the palette and apply it to color fills. This option provides fill colors that are more distinct than the ones provided by the Limited Mixing option. Select this option to have Origin automatically introduce complementary colors into the mix. Select this option to select a minimum level fill color ( From), a middle level fill color ( Middle) and a maximum level fill color ( To), and to fill a range of cells by using a gradation of three colors. Select this option to select a minimum level fill color ( From) and a maximum level fill color ( To), and to fill the levels between these extremes with a linear mix of the two colors. Use the color to Fill Background or Color Text of the cells in the selected range.Īgainst the background color of the cells, use the contrast color for the text Note: this value should be larger than or equal to the default value of the first level. Set levels by count specified by the text box value in the right side Set levels by increment specified by the text box value in the right side Please see details about the scale type here. Use it to specify the maximum value.Ĭlick this button to detect the maximum and minimum value based on the selected data range, and automatically set the To and From values. This is available only when Auto Rescale is unchecked. Select this check box to auto detect automatically the maximum and minimum value of the range. Use heatmap to color cells according to the level setting. Specify the text color for the cells with duplicate value. Specify the backgroud color for the cells with duplicate value. Use this tool to color cells with duplicate value. Specify the text color for the cells value matching the conditions of the rule. Specify the background color for the cells value matching the conditions of the rule. The default state is None but you can set the drop-down to either And or Or and create a second condition. Select the date value in the right side box.When the range (columns) Format = Date / Time When you select Custom, the Custom edit box shows.Click the triangle button to bring up the fly-out menu to call the value of statistics and the text-related functions.When the range (columns) Format = Numeric Use this tool to color cells that the value matchs the condition setting in the dialog.
OPENOFFICE CONDITIONAL FORMATTING BY DATE UPDATE
If you want to just update the range of the Conditional Format, you need to edit it in the Conditional Format Manager Note: for a worksheet, if you have added a Conditional Format, these tools dialog can support to update the rule, but not support to change the data range with the original Name. And in the same Worksheet, the name of Conditional Format have been used will list in this drop-box. Also, you can define the name by entering text. For example: if the range is from Column1 Row5 to Column4 Row10, the name will be C1R5-C4R10. In three dialogs of the tools, you can specify Range of the cells in the worksheet and Name for the selected range.īy default, the Name is first cell-last cell of the range. Select the cells in the worksheet, then right-click and select Conditional Formatting: Highlight/ Duplicate/ Heatmap.Select menu Worksheet: Conditional Formatting: Highlight/ Duplicate/ Heatmap.From Origin 2019, it supports three Conditional Format tools to color the cells in the worksheet.
0 kommentar(er)
