Understanding your data and how Excel's conditional formatting works is the key to accurately using icons to represent data.

Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.

Learn how to apply advanced formatting to your tabular data using Excel's conditional formatting options. Every marketer should know how to rock them.

Excel for the web now supports conditional formatting, and the interface is easier to use than the desktop edition. Susan Harkins shows you how to use it.

To use the Format Painter, select the cell or cells whose formatting you want to copy, and click "Format Painter" in the Clipboard group of the Home tab on the ribbon.