Excel: Conditional Formatting

Description: Make the business data more appealing using color or icon combinations. Old versions of Excel are having a limitation of maximum 3 conditions. In Excel 2007, we can have more conditions. Different options available are:-

Data Bars – Represent the data along with a graphical notation of the data.
Color Scales – Represent the value using color ranges
Icon Sets: - suitable for specific range of values like grades, ranks, etc.
Top/Bottom Rules: - Useful when we want to highlight Top 10 values or bottom 10% items or the items above/below average.
Highlight Cells Rule: - Useful when we need to apply the style using complex conditions.