More conditional formatting methods are introduced in Origin 2025b to better highlight the selected data in worksheet.
Highlight Max and Min
Both column-wise and row-wise highlighting are supported in Origin so you can choose which one to use depending on your scenario.
For example, here is a worksheet with average monthly highest temperatures over the past 6 decades. Each month is a column and each decade is a row. Choose Highlight Max Min -> Column-wise. The concentration of the highest global temperatures in the 2010s and 2020s provides empirical support for the long-term warming trend documented in climate science.
On the other hand, for this worksheet with average monthly highest temperatures with each year in a row, choose Highlight Max Min -> Row-wise. You can quickly find out in each year, which month has the highest temperature and which month has the lowest temperature.
If you want to customize the text and background colors of the max and min cells, please choose Open Dialog… in the flyout menu.
Highlight Top/Bottom N Items or N% of Items
Instead of only highlighting the maximum or minimum values , use the Top/Bottom… to highlight the top N numbers, Bottom N numbers, Top N% of Numbers or Bottom N% of Numbers.
Here is an example of water samples at different locations. Use Top/Bottom dialog to find the top 5 locations with highest Ca amount. A theme called top5 is saved so later you can select a new column e.g. Mg, and directly find 5 locations with highest Mg amount by choosing top5 in the flyout menu.
Showing <Last used> and saved themes in the flyout menu is common in other menus e.g. Analysis, Statistics, etc. Adding it for conditional formatting context menu is a nice add-on in Origin 2025b. It will save you a lot of time since you can apply our conditional format without needing to open the dialog.
A tip: If you are not sure what the saved theme or <Last used> theme is, press Shift key while clicking the theme in the flyout. The dialog will be opened with the theme loaded.
Pareto
For quality control or other purposes, you can use Pareto option to find out the most frequent items, least frequent items, most frequent N% or least frequent N %.
E.g. use Conditional Formatting: Pareto to find out where 80% of the defects are coming from so that you can put efforts in those issues.
The right side is a Pareto graph drawn by Origin. 80% of defects are from Over Shelf Life, Excessive Additives, No safety Labels, Package Defect and Excessive Bacteria. You can see the Pareto highlight in worksheet matches the graph.
For regions with existing conditional formatting, use the Conditional Format Manager to modify the parameters instead of starting from scratch. For example, let’s modify the rule to find out where 70% of the defects are coming from. You will see the Excessive Bacteria e.g. (row 87, 97, 98 in video) are no longer highlighted.
Note :Origin currently does not support applying additional conditional formatting rules to a range that already has an existing rule.
Highlight Outliers
You can also highlight outliers in numbers. Two Rules are provided. IQR and SD. You can change colors as well in the dialog.
Read this blog about other Conditional Formatting Methods introduced in Origin 2019.
Hope you like this improvement！ Any feedback is welcome!
English 
Japanese