Change Color Of Cells In Excel 2010 [Color Scales]

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.

colorsets Change Color Of Cells In Excel 2010 [Color Scales]

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.

New fomating rulw

Now you will see data cells with specified color scaling.

colr 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.

total field

Now you will see the spreadsheet with specified Color Scales for Total field, as shown in the screenshot below.

final

You may also be interested in our previously reviewed guides on Excel 2010 Data Bars & Icon Sets in Excel 2010.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *