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

Sure, I can help you with that! Here's how you can make a cell filled with color more transparent in Excel 2003:

1. Select the cell or range of cells that you want to change the transparency of.
2. Right-click on the selected cells and choose "Format Cells" from the context menu.
3. In the "Format Cells" dialog box, click on the "Patterns" tab.
4. Under "Background Color," select the color that you want to make more transparent.
5. Click on the "Custom" button at the bottom of the dialog box.
6. In the "Custom Colors" dialog box, adjust the "Transparency" slider to the desired level of transparency.
7. Click "OK" to close the "Custom Colors" dialog box.
8. Click "OK" again to close the "Format Cells" dialog box.

Your selected cells should now be filled with a lighter shade of the same color as your column heading. If you want to adjust the transparency further, simply repeat the steps above and adjust the "Transparency" slider as needed.

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

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

You can modify any color in ToolsOptionsColorModify.

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

On Fri, 6 Nov 2009 09:47:01 -0800, mbrown1
wrote:

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