Fill Color a Range

[Jack Gillis]

I want to fill a range with a color. I know how to do that but I don't
know how to keep the grid lines visible in that range. It seems I would
need a transparent color or something like that.

How can I fill a range with a color that will allow the grid lines to
show through?

Thank you.

 

[Bob Phillips]

The only way is to give the gridlines an alternative colour of their own.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Niek Otten]

When applying the fill color to the selection, also choose the Border tab.
Select Inside and Outline and choose a solid line type.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Earl Kiosterud]

Jack,

Color Fills paint right over the grid lines, even if you've used white. You
can use borders (Format - Cells - Border) to simulate the grid lines.

 

[Jack Gillis]

Thanks to all who replied. I get the picture now.

 

[Jack Gillis]

Thanks to all who replied. I get the picture now.