Conditional Format: Highlight Min and Max Values


Version: 2025b

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-30517


Select Columns or a region

Right click and choose Conditional Formatting ? Highlight Min Max sub menu

Choose Column-wise to color min and max values column-wise, e.g.

image-20250319-191315.png

Choose Row-wise to color min and max values row-wise.

image-20250319-191814.png

Choose Open dialog to customize colors or only highlight min or max

image-20250319-191927.png

Click > button and choose Generate Script to see corresponding X-Function.

//C1R1-C0R0 means from column1,row1 to last column, last row
//min.use=0 means don’t highlight min
wcolorbycr name:="C1R1-C0R0" min.use:=0;