View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.misc
[email protected] mr.george.t.lopez@gmail.com is offline
external usenet poster
 
Posts: 1
Default Grid lines obscured by fill color

On Tuesday, April 1, 2008 at 3:03:51 PM UTC-7, 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.


This is what I use because I want colors but still wanted the faint gridline to organize the data.

My solution: Highlight the area you want the gridlines (likely the area you colored and lost them) - Right click - format cells - select the normal border size on the bottom left of the style box - under the color option select "Tan, Background 2" (this is a pre-set option third over right on the top selection - next ensure you select the type of border you want (this is the sample box that says "none, outline, inside, etc.) - finally click okay. You should now have a faint grid border that blends with the original grid marks un-noticingly (yes I made that word up :)

You can then use the same steps to add a black border around your new grid like border to better present your colored grid lined chart. :)