Sometimes you want to sort a set of rows depending on the values in one shared column or columns depending on the values in one shared row. I used this for example to rearrange the frequency tables for the character combinations.
In Excel you can format cells depending on a condition. Most of the settings are evident. I recommend checking out the different options of conditional formatting by playing around with it. This post will give you an introduction to this feature.