Color Scales Conditional Formatting
One of the new conditional formatting options introduced in Excel 2007 is called Color Scales. It shades cells based on their value. I just posted a file in the Download section that uses this feature in a way that probably wasn't anticipated by the designers: Animated Color Scales.
A 62x62 range of cells contains formulas that are driven by three other cells. A few simple VBA macros select random colors, rescales the display, and even animates it. It's kind of fun, and you'll be amazed at some of the colorful patterns that come up.
Here are some thumbnails of what you can expect:
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.