Make your Excel data pop with conditional formatting
May 19, 2011 Leave a comment
You’ve got your numbers input and organized but they still don’t jump out at the people who look at your worksheet. You want to give them the big picture at a quick glance. This is where conditional formatting can help.
The Microsoft provided workbook samples below show three examples of conditional formatting. The first two examples use easy to apply built-in formats, and the third example uses a rule based on criteria that you define and apply by using a formula.
Example 1 is a graded color scale:
Here is the formula
Example 2 is an Icon Set:
Here is the formula:
Example 3 is a custom formula:
Formula for the custom formatting:
So my advice is to try some tests of your own to see what kind of formatting might help display your data so others can see the impact you are trying to make. Give it a try and let us know what you think.