Fill Color a Range

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)


"Jack Gillis" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>

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 Gillis" <[email protected]> wrote in message
news:[email protected]...
>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.
>

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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Jack Gillis" <[email protected]> wrote in message
news:[email protected]...
>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.
>

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

"Jack Gillis" <[email protected]> wrote in message
news:[email protected]...
>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.
>

Thanks to all who replied. I get the picture now.
"Jack Gillis" <[email protected]> wrote in message
news:[email protected]...
>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.
>