One overlooked capability is the ability to format Excel worksheet cells so that the final result is that they convey information visually rather than through numbers. There are many applications of this technique such as creating a Gantt chart, or managing conditional formatting for more than 3 conditions.
Conditional Formatting works well for up to three conditions.
But even when the number of conditions exceeds that limit, it is possible to do
without any programming support. For example, one possible
way to show twelve possible rankings through color is shown in Figure 1.

Figure 1
The effect requires no programming and relies on just a set of conditional formats.
To get going, set the column width for columns C:F to 1.

Figure 2
As the values in B1:B12 change so do the colors of the cells in columns C:F.