Forum Discussion
color cells
How do I keep the gridlines when I color more than one cell?
example if I color 5 cells - my gridlines disappear
3 Replies
By only applying color in the form of a Style, which also applied boundary formats and cell protection. You can define/modify your own styles to meet the needs of your workbooks.
- thanks but I am sure it is easier than this...it has to be something I am simply missing
example: If I am coloring 5 cell boxes - I want my gridlines to stay there NOT disappear -
I just want to see my gridlinesMaybe you are right but I do not believe it to be so. I used a white or pale colour fill for many years because I saw no benefit in placing my numbers in little boxes. If I wanted to define a heading or the foot of a table, the gridlines can be replaced by a border coloured as white, darker 15%.
Now I am kinder and simply use View / Hide Gridlines so that the end-user can reinstate the grid if they think it serves some purpose.
