I’ve been playing around with Excel 2007’s conditional formatting. Here’s a 150×150 range of cells that uses one of the new color scale conditional formats. It’s a plot of SIN(x) x COS(y) for x and y values ranging from 1-4.
I used ;;; number formatting to hide the numbers in the cells, so all you see is a very cool gradient contour “chart.” This is a small version. Click the image to see a larger one (captured while the screen was zoomed to 10%).
The amazing thing is how fast it is. If I change the formula or the increments, the color refresh is almost instantaneous.