Hi Statalisters, many of you may know this feature from MS Excel (from Version 2007 on). It's more or less a "choropleth map" for data tables (cell colour depends on cell value relative to the table distribution or on conditions). (see:http://msdn.microsoft.com/en-us/library/bb4289...
> It's more or less a "choropleth map" for data tables (cell colour > depends on cell value relative to the table distribution or on > conditions). > (see: > http://msdn.microsoft.com/en-us/library/bb428945%28office.11%29.aspx) > > > In my work I often have to display both...
cell.Interior.Color = cell.Value End If Next cell End Sub not"RGB" as I was expecting! The Cell content has to be: (Blue*256+Green)*256+Redto get the right colour!!!
> > On Fri, Oct 16, 2009 at 3:33 AM, <Stefan.Gawrich@hlpug.hessen.de> > wrote: >> >> many of you may know this feature from MS Excel (from Version 2007 > on). >> It's more or less a "choropleth map" for data tables (cell colour >> depends on cell value relative to ...
On Fri, Oct 16, 2009 at 3:33 AM, <Stefan.Gawrich@hlpug.hessen.de> wrote: > > many of you may know this feature from MS Excel (from Version 2007 on). > It's more or less a "choropleth map" for data tables (cell colour > depends on cell value relative to the table ...