Excel only displays 56 colors at a time. The color value is RGB, but it
won't be the RGB value you set unless are just lucky. It sets the value to
the closest color to the RGB value.

If you go into Tools=Options=Color Tab, you will see there are very few
colors I would call dimmer shades of other colors in the palette. You can
create your own custom palette of course.

See David McRitchie's page on this:
http://www.mvps.org/dmcritchie/excel/colors.htm

--
Regards,
Tom Ogilvy


"Jeremy Gollehon" wrote in message
...
I know I can read the RGB value of a color in VBA.

Is there a consistent way to do a calculation on those values to visually
return the same color but lighter (dimmer)?

Thanks,
Jeremy