Course Content

Course Content

Description

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.

FAQs

Recommended Courses

Share With Friend

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

Download The Apps

Code Scan or Download the app
Google Play Store
297K+ Downloads
4.5 Rating
10K+ Reviews
  • 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