openoffice conditional formatting contains

Example 2: Create a Heatmap Using the Scores.Example 1: Highlight Scores less than 35.Conditional Formatting in Google Sheets – Examples.How to Access Conditional Formatting in Google Sheets.Here are some practical examples of using conditional formatting in Google Sheets. Conditional Formatting in Google Sheets – Examples For example, a score of 34 would be a lighter shade of red and 10 would be a darker shade of red. ‘Color scale’ can be used when you also want to visually present the difference between the values in the cells. In this case, irrespective of whether the score is 34 or 10, both will be highlighted with the same color. For example, I can use this to highlight all the cells with scores that are less than 35. ‘Single color’ can be used when you want to highlight all the cells based on the value. Now there are two options available to you when you use conditional formatting in Google Sheets: This opens the ‘Conditional format rules’ pane on the right that you can use to set the rules. How to Access Conditional Formatting in Google SheetsĬonditional formatting can be accessed by going to Format → Conditional Formatting. Similarly, you can use many such conditions (as we will see later in this tutorial) to highlight cells based on the value in it. Conditional Formatting in Google Sheets can be used to highlight/format cells based on the values in it.įor example, if you have the scores of 50 students in a subject, you can quickly highlight the students who have scored less than 35 in the exam.

Openoffice conditional formatting contains