Conditional Formatting in Origin 2019

Excel has a very useful and fancy way to visualize data directly on the spreadsheet called “conditional formatting”.  Now that is also available in the coming Origin2019 with three options

  • Highlight: Color cells that meet the condition
  • Heatmap: Color cells by values using a palette or a color list
  • Duplicates: Color cells with duplicate values

The idea of conditional formatting is to easily identify the key pieces from large datasets, by applying special formatting to cells in the spreadsheet that meet certain criteria. It visually calls user’s attention to important data points like outliers or a certain event.

Some examples:

Highlight with built-in Condition

Highlight sales greater than specified value

Highlight with User-defined Condition

Here is a block of measurement data and I’d like to find outliers that be outside 1.5*StdDev

Highlight Duplicates

I have gene profiles from two different samples, and I’d like to cross compare to see if there will be matching pairs.

 

Heatmap

Visualize this sales data by cell values in worksheet — The sales usually start high at the beginning of the year and keep going down

How to apply basic conditional formatting?

Highlight the targeting range and hit the menu Worksheet: Conditional Formatting.

How to management existing conditions?

We support multiple conditional formats in different regions of worksheet. And you can choose  Worksheet: Conditional Formatting: Conditional Format Manager to config it further (condition/color/etc.) or delete it.

Related Posts

About S Z

Male, single, alive.

View all posts by S Z →

Leave a Reply

Your email address will not be published. Required fields are marked *