conditional formatting | Chapter 1 | greater than

                                   Conditional Formatting

 

In this topic we are going to excavate a very important and serious application of excel. We will understand how it works precisely.

                                     
                                         

After clicking conditional formatting button several options are available including sub options.

Highlight cells rules further categorized as

Greater than 

 

Under this function content of cells that are greater than a specified number are highlighted. After selecting the data set (A5 to C9) click Greater than option.

There are various highlighting option. We opted here 'Light Red fill with dark Red text". Highlighting option can be customized.

Excel has selected greater than 400 from the above data series. And the selected data are pinned with Red.In the Greater than window the Red circle indicates that by clicking on we can separately denote a cell containing the value greater than 400 instead of writing 400 in the space left.

Less Than 

By clicking the Less than option under Conditional Formatting we are highlighting those values that are less than 60.

Between 

 

This option determines the values between two specified extremes. 

Highlighting values between 41 to 74. 

Equal to

Highlighting 25 only. 

Text That contains....... 

Lets understand this function with a help of a video.

A date occurring 

 

This format only works when you are working on the basis of the current month (when system date is the basis of the working date)
Since we are at this moment in the month of September 2019.
The video will help you to understand this format.

Duplicate values/Unique values 

This format is widely used among the conditional formatting option. We will fetch the duplicate values and unique values from our data range in the custom manner.Watch the video

Some important tips on duplicate values.

Similar values or text are highlighted under duplicate value format.
This format is sensitive. If two data looks apparently same, but one is followed by spaces then it will pinned those two as unique.It ignores uppercase & lowercase. Similar values with different cases (one is in upper case and another one in lower case) are pinned as duplicate values. 
Practice with your own data.