How To Apply Conditional Formatting In Excel – MS Excel Conditional Formatting Tutorial Part 2

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.

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]

conditional formatting in excelStep 2: Go to the option “Conditional Formatting” and in conditional formatting select the option “Highlight Cells Rules”.

conditional formatting in excelStep 3: In the “Highlight Cells Rules” option select “Greater Than”.

conditional formatting in excelStep 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”.

conditional formatting in excelStep 5: We are done!

conditional formatting in excel

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.

Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">