Ask Your Question

Revision history [back]

You could make a macro to do this. See here

Other options are out there such as creating new styles and using conditional formatting but you will not get the range in colors.