Visualizing data Using Conditional Formatting

Conditional Formatting is a useful tool for Visualizing numeric data. Sometimes, Conditional formatting is a Viable alternative to creating a Chart. Conditional formatting is an easy way to quickly identify cell entries or cells of a particular type.

Below Picture shows usage of different Types of conditional formatting rules:


Here’s a brief explanation of each:

1) Greater Than 20: Values Greater than 20 are highlighted with a different background Color.

2) Below Average: Values that are lower than the average values are highlighted.

3) Duplicate Values: Values that appear in the range more than once are highlighted

4) Data Bars: Each Cell displays a horizontal bar, the length of which is proportional to its value.

5) Icon Set: It Displays a small graphic in the cell. The graphic varies, depending on cell value.

6) Colour Scale: The background color varies, depending on the value of the cell.

7) Letters other Than A: If the Cell contains Text other than A, the cell is highlighted

8) Custom Rule: The rule for above shown pattern is based on formula: =MOD(ROW(),2)=1

Hope you like this Post. Stay Connected and we will learn more awesome things in Excel.

Download Excel sheet (71 downloads)


Be the first to comment

Leave a Reply

Your email address will not be published.