Conditional Formatting for Ranking

The following example describes how conditional formatting can be applied to results to show ranking.

Suppose an analysis includes ten ranking categories, with a value of 1 in the column indicating the worst ranking, and a value of 10 indicating the best ranking. You could create three conditional formats to show the following:

• One image to indicate a low rank for columns that contain 1, 2, or 3.

• Another image to indicate an average rank for columns that contain 4, 5, 6, or 7.

• A third image to indicate a high rank for columns that contain 8, 9, or 10.

In the Graphics dialog, selecting the Images Only image placement option would cause the columns to be displayed with only images, and not the ranking numbers, in the results.