How to make a cell filled w/color more transparent?

[mbrown1]

My column heading is filled w/color. Want to make column below same color
only more transparent. In other words, lighter shade of same color as
heading.
Using Excel - 2003

 

[Gord Dibben]

Excel 2003 has shades of colors like dark and light green or blue.

If those don't suit........................

You can modify any color in Tools>Options>Color>Modify.

Say you have Blue as color for column heading.

Note the RGB values for that color.................0,0,255

Pick another color you would never use like Tan or Rose or puke green.

Modify that color to lighter than the RGB values for Blue, say
.............100,100,255

Note: this is saved with the workbook, not globally.


Gord Dibben MS Excel MVP