Conditional Formatting

Excel: Conditional Formatting – Color Scales

This is another in a series of Excel’s Conditional Formatting How-To's. The previous post looked at the Highlight Cell Rules option. (For Details See: Excel Conditional Formatting Highlight Cell Rules). In this article we are going to look at another option namely: Color Scales. Using Color Scales is a popular formatting technique that lends itself

Excel: Conditional Formatting – Highlight Cell Rules

Excel’s Conditional Formatting command allows for a simple and quick method to format a range or a table of cells based on the value of the data contained in those cells. This allows us to actually see certain features of the data. Over the next few Posts we are going to look at examples to