View Single Post
  #5   Report Post  
Old April 2nd 08, 03:56 PM posted to microsoft.public.excel.misc
Paul Paul is offline
external usenet poster
First recorded activity by ExcelBanter: Mar 2008
Posts: 43
Default Grid lines obscured by fill color

Thanks for that, Hutch. I'll hold off for now because I'd have to
undo the cell borders when the (temporary) fill color is removed.

On Apr 1, 6:24 pm, Tom Hutchins
One workaround...

Add cell borders to repalce the invisible gridlines. Select the block of
cells, right-click, and select Format Cells. On the Border tab of the Format
Cells dialog, select a line style. Click the Outline button, then the Inside
button, then OK.

Hope this helps

"Paul" wrote:
When I apply a fill color to a block of cells, the grid lines don't
show in that block of cells. I don't expect that there is a way to
force the grid lines to show, but I'm hoping that I'm wrong. Thanks
any workarounds, if they exist.