Microsoft Excel’s conditional formatting is a wonderful “automatic” feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells. For example, ...
When you've got a chart-heavy Excel spreadsheet, you can display one chart and let the viewer switch to see the others from a drop-down. The Pointy Haired Dilbert blog runs down the details of this ...