mdpax.blogg.se

Openoffice conditional formatting cells with duplicate data
Openoffice conditional formatting cells with duplicate data











openoffice conditional formatting cells with duplicate data

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.

openoffice conditional formatting cells with duplicate data

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.













Openoffice conditional formatting cells with duplicate data