Course Content

Course Content

Conditional Formating in MS Excel

How to use Conditional Formatting


Now we will see that what is conditional formatting in MS Excel.

Now we will see that what is conditional formatting in MS Excel. Conditional formatting actually means that formatting using any particular condition. Conditional formatting button is located in HOME tab.

Suppose we have a salary column in our Excel sheet and we want to highlight salaries which are greater than X amount, then we will use conditional formatting.

We can place our conditional amount, and also select how we want our cells to be highlighted i.e. by changing font style, or color, or background color.

Conditional formatting is always dynamic in nature.

Suppose we want to clear conditional formatting which we have applied, so for that we can go to conditional formatting column and select 'Clear rules'. We can select particular cells where we want to clear the formatting rules, otherwise we can clear rules from entire sheet also.

We have also option for showing bar in conditional formatting, suppose when we are in any presentation or important meeting and when we want to discuss anything related to salary but do not want to display the particular numbers, then we can use 'Show Bar Only' option, which us present in 'Edit Formatting Rule' dialog box.

We have one more option in conditional formatting that is Color scales, in which there are different color format according to data going from high to low. Highest data will be represented with green background colour while the lowest data will be represented with red background colour, and the mid data will be set accordingly.

The most preferable thing in conditional formatting is Icon sets.


Conditional Formatting (CF) is a tool that lets you apply formatting to a cell or a range of cells and have that formatting alter based on the cell's or formula's value. You can make a cell bold only when the value of the cell is more than 100, for example.

  • Background Color Shading (of cells)
  • Foreground Color Shading (of fonts)
  • Data Bars.
  • Icons (which have 4 different image types)
  • Values.

  • Select the cells to which conditional formatting should be applied. Drag from the first cell in the range to the last cell in the range.
  • Select HOME > Conditional Formatting > Highlight Cells Rules > Text that Contains from the drop-down menu.
  • Click OK after selecting the text's colour format.

Select Conditional Formatting > New Rule... from the Home tab of the ribbon. Select 'Select only cells that contain' from the drop-down menu. The first dropdown should be set to 'Cell Value.' From the second dropdown, choose 'greater than.'

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere