Should I Use Data Bars, Colour Scales Or Icon Sets In Excel?

The Conditional Formatting tool in Excel is an extremely useful part of the application. When reporting figures in the format of tables full of numbers either to individuals or groups, it has long been recognised that a visual representation will help to get the meaning of the numbers across. The value in one field is 65, but is that good or bad? It usually depends on what you are comparing it to. Conditional formatting provides a simple way to show a comparison between figures in a table or the meaning behind the figures without having to spend time compiling a full report with pages of pie charts and fancy bar graphs.

The full article appears here:
http://www.microsofttraining.net/article-1936-should-i-use-data-bars-colour-scales-or-icon-sets-in-excel.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com