Fill Color a Range

  • Thread starter Thread starter Jack Gillis
  • Start date Start date
J

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.
 
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)
 
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
 
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.
 
Back
Top