

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.
