Hi John:

An Excel workbook has only a 56-color palette, so it's entirely possible
that color hues that are different but close will be rendered identically.

Regards,

Vasant.

"John A Grandy" wrote in message
...
when setting

oRange.Interior.Color

for two ranges which have bordering cells, where a different hue of the
same
basic color is used for each range, could it be possible that Excel would
decide to alter the color for the second range to be the same as that of
the
first ?

Oh, it only has a 56 color palette .... I thought it was that only 56
numerical color indexes were defined ... but you are telling me that it is
not possible to use colors outside of this 56 color palette ...

"Vasant Nanavati" wrote in message
...
Hi John:

An Excel workbook has only a 56-color palette, so it's entirely possible
that color hues that are different but close will be rendered identically.

Regards,

Vasant.

"John A Grandy" wrote in message
...
when setting

oRange.Interior.Color

for two ranges which have bordering cells, where a different hue of the
same
basic color is used for each range, could it be possible that Excel
would
decide to alter the color for the second range to be the same as that of
the
first ?