That's exactly what I need.
The limitations don't matter at all.
It's just for getting an fast overview
of the number distributions.
Thank you very much, I would appreciate
if you could send me some code.
Regards, Stephan

ps: The heatmap would be perfect!
That's how I've seen it in Maple and
it suits fine.


"Tim Williams" <saxifrax at pacbell dot net schrieb im Newsbeitrag
...
You can do this but you should be aware of a couple of points around cell
colors.

1. If you assign a background color to a cell via code then Excel will
map
it to the nearest color in the workbook's color table
2. ....so you'll be limited to a maximum number of different colors.

Neither of these is a big issue since you can remap the workbook's color
table to match the colors you need to use, and using more than 20 or so
colors is normally enough.

I've done both simple gradient and "heatmap" type coloring (blue=low,
red=high) in Excel and it works well.

Contact me via email if you need sample code or I can post some here if
you
prefer.

Tim.