What if you want to apply a fourth color? Well, it is pretty simply (maybe to simple to put it into a blog): Give all your cells the fourth color and then apply the three "additional" colors through conditional formatting. See the animated image below:
The conditional formatting was applied through this set of rules:
Of course this will only work, if all cells in column C of this table are filled with values. Otherwise we would only have an empty blue cell. This approach is nice if you always have values in your cells and is good for assign a color to some kind of "bottom values". If you want to read more about the limitless of conditional formatting please read the post on creating matrix paper with conditional formatting. As always, please feel free to comment.
Discuss this blog post in the forums (click the blue button)
