Excel 2010 have many data visualization tools which provide best way of presenting data either in pictorial representation or with advanced conditional formatted style. Color Scales is an advance level conditional formatting which allow users to show data scaling with different colors, this will eventually make data easier to comprehend by concerned audience, as they can easily infer overall evaluation of dataset by just glancing at spreadsheet.
Launch Excel 2010 spreadsheet on which you want to show Color Scales. For illustration we have included a spreadsheet containing fields; marks in different course fields and Total.
Now we will be applying different Color Scales to make the data in spreadsheets more prominent and self-explanatory. We will select all the course fields. Navigate to Home tab, and from Conditional Formatting options, select More Rules from Color Scales menu.
In New Formatting Rule dialog, under Select a Rule Type, choose the desired rule and under Format style, select either 2-Color Scale or 3-Color Scale. From Minimum, Midpoint and Maximum, select desired Type, Value and appropriate Color.
As shown in the screenshot below, we have selected Number from Type, entered Value based on grading rationale, and chose Color (we have selected red for minimum value, yellow for midpoint value, and green color for highest value). Click OK to continue.
Now you will see data cells with specified color scaling.
Now for Total field, we will be applying Color Scale again. Move to New Formatting Rule dialog, select different color scales for different values and click OK.
Now you will see the spreadsheet with specified Color Scales for Total field, as shown in the screenshot below.