Coloring a 200 column X 200 row matrix of numbers with colors based on values

Coloring a 200 column X 200 row matrix of numbers with colors based on values

Post by William Coo » Fri, 13 Sep 1996 04:00:00



I have some equipment that produces a very large amount of numbers. They
can be imported into Excel from a *.csv file. However, I now have to
color those numbers based on a value range.  An example may be;

Numbers from 5.2 to 25.6
Now I want to be able select the following:
1.      The number of ranges. Example, break up the colors as follows:
        5-10 red
        10.1 to 15 yellow
        15.1 to 20 orange
        20.1 to 25 green
        > 25 white
2.      Or, to chose a number of colors, say 10 colors and have the macro
determine the thickness range.

Any Help?

Bill Cook
Malaysia

 
 
 

Coloring a 200 column X 200 row matrix of numbers with colors based on values

Post by John Walkenba » Sat, 14 Sep 1996 04:00:00


I recently posted an Excel VBA macro that will work for this. You can
get it at my web site:

http://www.j-walk.com/ss/tipoweek.htm

John Walkenbach


>I have some equipment that produces a very large amount of numbers. They
>can be imported into Excel from a *.csv file. However, I now have to
>color those numbers based on a value range.  An example may be;

>Numbers from 5.2 to 25.6
>Now I want to be able select the following:
>1.  The number of ranges. Example, break up the colors as follows:
>    5-10 red
>    10.1 to 15 yellow
>    15.1 to 20 orange
>    20.1 to 25 green
>    > 25 white
>2.  Or, to chose a number of colors, say 10 colors and have the macro
>determine the thickness range.

>Any Help?

>Bill Cook
>Malaysia


 
 
 

1. P5-200 or P6-200

Hello,

I need to buy a couple of machines for work, and I'm having trouble  
deciding between a P5-200 or a P6-200 (both are Gateway machines).  Will  
NeXTStep 3.3 or OpenStep 4.0 take advantage of the 32 bit features of the  
P6?  Does anyone have performace data for NeXTStep on the two processors?  
Will there be much of a speed difference between two systems assuming that  
they are both using EIDE drives and Matrox Millenium video cards?  How  
much of a difference will a SCSI controller and a fast scsi disk make?

Thanks in advance,

-Mike Tie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Department of Math/CS           phn: (507) 663-4067
Carleton College                fax: (507) 663-4312
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

2. LOOKING FOR - UI Architect - Palo Alto, CA - 6-12 Months

3. Dell PPro 200n vs Micron PPro 200 vs Gateway PPro 200 [COMMENTS WANTED]

4. Parameter passing modes in IDL

5. K6 200 vs Cyrix M2 200

6. Failed to open the Group Policy Object. You may not have appropriate rights

7. Pentium Pro 200 Mhz faster than Sparc Ultra 200 Mhz !! ??

8. GPO question...

9. Pentium 200 256K and 200 512K on same board

10. Notebook: 486DX2/50, 8.4"Active Color, 4/200 - $820

11. 123 - How to color values in a column based on value