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.


Excel's conditional formatting is a powerful feature, but a little too powerful. It can change the appearance of cells based on conditions that you set. Conditional formatting is a great way to highlight particular cells or ranges of cells. Conditional formatting can be used to highlight the sales month, the "new" status of a product, and so much more. But because there are so many possible conditions, editing a conditional format in Excel can be tedious. This is why Conditional in Excel was created - it simplifies the process of creating and editing conditional formats by giving you just what you expected.

Conditional formatting is a feature in Microsoft Word that allows writers to control the formatting of text based on one or more conditions. Conditional formatting uses one or more input fields and a choice of formats for text in those fields to display. To apply conditional formatting, you need to select the cells where you want to apply this type of format. Then, select "conditional format" from the "format" menu. Finally, choose your conditional format from one of these types: Cell Value Only: This condition evaluates whether the cell value is equal to a specific value like 0, 10, 100, etc. When it finds this condition true, it will draw a line through the cell and change its background color based on its color scheme.

Conditional formatting is a feature of Excel 2016 that allows users to change formatting based on conditions. This can be effective in different circumstances such as because of dates and data labels. There are two types of conditional formats: conditional formats and custom conditional formats. Conditional formatting is a feature of Excel 2016 that allows users to change the appearance of cells based on conditions defined by the user. Conditional formatting is a feature that allows you to highlight cells in a worksheet based on different conditions. In this tutorial, we will use conditional formatting to highlight the values in the green cells only if they match certain criteria. In order to create conditional formatting, you need to have two conditions - one for the condition and one for the result. In our case, we will use a formula based on a comparison between green and red values as a condition and highlight any cell with a green value as an outcome.

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
App Store
397K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
13K+ 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