Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Cell colors and Comments transparent to gridlines & values

Posted by M Bush on July 26, 2001 10:15 AM

How do you color cells so that gridlines show on the display monitor and in the print-out? Also, is it possible to have comments displayed transparent (e.g. object sent to background, etc.) so that they do not block-out values or gridlines?

Re: Cell colors and Comments transparent to gridlines & values

Posted by Mark W. on July 26, 2001 11:13 AM

> ...so that gridlines show...on the display
> monitor and in the print-out

They do if you check the "Gridlines" check box
found on the Page Setup dialog's Sheet tab.

> ...is it possible to have comments displayed
> transparent...

You could choose the "None" or the "Comment
indicator only" radio button on the View tab
of the dialog produced by the Tools | Options
menu command.

Re: Cell colors and Comments transparent to gridlines & values

Posted by mseyf on July 26, 2001 12:17 PM

To get the gridlines to show on colored cells, you have to add borders to the colored cells (Format>Cells>Borders) Gray-25% usually matches the normal gridlines.

HTH

Mark

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.