In previous post, we learnt about why do we need conditional formatting and types of conditional formatting (Part 1). In this tutorial, we will learn how to apply conditional formatting.
- Introduction To Conditional Formatting In Excel
- How To Apply Conditional Formatting In Excel
- In-built Conditional Formatting Rules In Excel
- How To Create A Conditional Formatting Rule In Excel
- Useful Applications Of Conditional Formatting In Excel
Let us suppose that we have a small student database which contains two fields “Student name” and “Student marks”. To understand this topic easily let us assume that we wish to highlight the students who have scored above 90, in order to reward them.
Step 1: To apply conditional formatting we have to first select the range of cells where conditional formatting has to be applied.
[Enlarge the image by clicking on it for a better view]
Step 4: As soon as you click the “Greater Than” option a window will appear. Enter “90” in the value field. We can also choose the color with which we want to highlight the values greater than 90. In this case we have chosen “Green Fill with Dark Green Text”.
Vow, it was pretty easy, wasn’t it? So now that we know how to highlight cells based on a criteria, we will learn about how to highlight top or bottom items in a list, highlighting cells using data bars, icon sets and color scales in our next tutorial.