Make your Excel data pop with conditional formatting

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:

Graded Color Scale

Here is the formula

Formula for Graded Color Scale

Example 2 is an Icon Set:

Icon Set

Here is the formula:

Formula for Icon Set

Example 3 is a custom formula:

Custom Formula

Formula for the custom formatting:

Formula for 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.

Advertisements

About SCB Enterprises
System Solutions and Integration

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: