Conditional Formatting: Highlighting values less than specified value

In this post we will see how to highlight values which are less than specified value. We can do this by using Conditional Formatting.

For this we will take an example. We have listed marks of 10 student in different subject in an excel sheet. 

YouTube Video

Now, we want to highlight the marks which are less than 40. But how?? Let’s follow below steps:

1. Select all the values from which we want to highlight the values which are less than 40.

2. Go to Home Tab --> Styles Group --> Select Conditional Formatting --> Select Highlight Cells Rules --> Select Less Than option

3. Less than window will appear as shown in below image.

4. Enter value 40 as we want to highlight values less than 40 in 1st input.

5. Select the formatting style from available drop down list in 2nd input.

6. Selected value and selected formatting style will be seen as shown in below image. Click OK.

7. We can now see all the values which are less than 40 are highlighted with selected formatting style. 

This is so simple!! You can try highlighting values less than specified values by using different values and different formatting styles. If you have any queries related to this topic you can write in comment box below.