How To Define Top 10 Conditional Formats In Excel For Mac


show more Defining Top 10 conditional formats provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Defining Top 10 conditional formats

Sometimes, it seems like we are inundated with Top Ten lists: Top Ten movies, Top Ten vacation spots, and so on. Businesses also use Top Ten lists to reward their employees, perhaps giving awards to their top ten sales representatives. In this movie, I will show you how to find the highest and lowest values in your worksheets and change those cell's formatting so that the value stand out. I am going to work with a fairly simple example, just so you can see how these conditional formats work. They are called Top Ten Formats, but you can use any number that you want. So, for example, here I have a data list that has numbers 1 to 10.

If I want to create a conditional format that changes the formatting of the cells that contain the top three values, I can select the cells, and then on the Home tab of the Ribbon click the Conditional Formatting button, point to Top/Bottom Rules, and then click Top 10 items. In the New Formatting Rule dialog, I can select either the top or the bottom value...

Defining Top 10 conditional formats
Video duration: 4m 19s 6h 32m Beginner

Viewers:

Defining Top 10 conditional formats provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...