Microsoft Excel 2010 – Conditional Formatting

If you follow the stock market like I do, you may notice that Google Finance has a neat way of showing trends.  It puts the stocks that gained in value in green, and the stocks that lost in value in red.  This is a very helpful way to display data to show trends.

Conditional Formatting is an Excel tool that allows you to create this kind of effect.  Conditional Formatting is not new to Excel 2010;  it has been around since Excel 2003.  This is an incredibly helpful tool, but one that can easily be overlooked by a novice.   Today, I am going to show you how to put conditional formatting into practice!