Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamically load DataValidation List through Source field? | Excel Worksheet Functions | |||
Adding a Background to a date in a field | Excel Discussion (Misc queries) | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Linked date field in worksheet defaults a blank field as 1/0/1900 | Excel Worksheet Functions | |||
Dynamically changing a calculated field in Pivot Table | Excel Programming |