For the color ramp part of the problem you might find ColorRamp1785 useful.
In reply to Re: visualizing data in a table by BrowserUk in thread visualizing data in a table by punkish