Bookmark and Share

Enter your email address:

Delivered by FeedBurner

Home Page

Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!

eXTReMe Tracker

  Friday, August 01, 2008 – Permalink –

Rank formatting

Highlight the best

Use Conditional formatting to highlight the rank of items in a list.
Select the range. Go to Format>Conditional Formatting....

Change the first box to "Formula Is".

Enter the following formulas. (Click Add to set the 2nd and 3rd Condition.)


Rank Conditional Formatting

(Notice the three way tie for third.)

Does a tie for first or third make sense?

If you want a unique rank, try a formula like:


This will rank the numbers in the order they appear in the list.

For a detailed discussion of ranking see:

Chip Pearson:
Ranking Data In Lists
(There is a workbook you can download)

[Edited entry from 4/11/2005]

See all Topics


<Doug Klippert@ 2:40 AM

Comments: Post a Comment

Links to this post:

Create a Link