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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |