![]() Use this tool to color cells that the value matchs the condition setting in the dialog. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |