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.