How color a cell with a lighter shade?

J

Jack

Re Excel 97 --

Is there a way to color a cell with a lighter version of the colors that are
offered? For instance, I'd like to use a lighter shade of yellow.

Jack
 
J

J.E. McGimpsey

If you're doing it in VBA anyway, just reset the color in the color
palette to what you want:

ActiveWorkbook.Colors(36) = RGB(255, 255, 200)

then use ColorIndex to apply it:

Range("A1").Interior.ColorIndex = 36
 
Top