How color a cell with a lighter shade?

  • Thread starter Thread starter Jack
  • Start date Start date
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
 
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
 
Back
Top