Download the New LearnVern Android App and enter Lucky Draw to win Free Certificate
If you are facing any issue in playing video please use Firefox browser.
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.
Have a friend to whom you would want to share this course?