View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stephan Schnitzler Stephan Schnitzler is offline
external usenet poster
 
Posts: 3
Default Q: assign field background color dynamically according to field values

Hi,

I need to assign background colors in an excel sheet
according to the integer values within the fields.

i.e. I have Matrix with entries between 1 and 100, where
1 should be a dark color, 100 a bright color and the values
between accordingly.

I have seen this browsing matrices in Maple.

Conditional Formatting doesn't do the job as
I need more subdivisions than I am willing to do
by hand.

Does anybody know a resource that could help me
or is anybody able to provide me with a VBA code?

Thanks a lot - Stephan