Excel Tips Tutorial: How to Use Conditional Format in Microsoft Excel
This is a very useful option in Microsoft Excel, Conditional formatting highlights interesting cells, emphasizes unusual values, visualize data using data bars, color scales and icon sets based on the criteria and conditions you set.
The first option in Conditional Formatting is the “Highlight Cell Rules”. To highlight the interesting cell, select the data first and click on conditional formatting and select “Highlight Cell Rules”
There will a list come when you select highlight cells rules, choose your desired criteria which need to be highlighted, I am choosing “Greater than…”; when you click on Greater than, it’ll ask you the criteria and also the format which you want.
It will highlight the percentages which are greater than 30%.
The second option is “Top/Bottom Rules”, once again select data which you want to format as Top/bottom should be highlight, choose your desired criteria i.e. Top or bottom rule. It can be in percentages or can be in values. I’ll select Top rule to make you understand.
It will ask you the number of top cells you want to highlight, I’ll select 2 in the example.
You can see it highlighted the top 2 values i.e. 70% and 52.50%. Other options in “Top/Bottom Rules” can be used with the same pattern.
Data Bars, Color scales and Icon sets are similar to other conditional formatting areas which you have learned above, you just have to select data and click on the desired criteria. It will format the cell accordingly.