Formatting Issue Excel 2007 in VB

[MS]

You have values 1 to 10 in 10 cells. You then apply 2 tone formatting cells
based on highest and lowest value with the highest value color being grey
and the lowest value white. When doing this the cells will be colored in the
various tones of grey to white based on the values of the cells. How do you
get the equivalent color values in the conidtional format so that you can
use those colors in the normal cell VB formatting. E,g.

Cell1.Interior.Color = 15921906 [White]

Cells2

.....

Cells 9

Cell10.Interior.Color = 8355711 [Grey]


Thus want to programatically determine the color numbers for all the shades
using VB

Thanks in advance

 

[MS]

Dont worry have done