Click the Microsoft Office button
Click on the Excel Options button to bring up the Excel Options dialog box (at the bottom of window)
Click on the Advanced button in the left hand pane
Scroll down to the section: Display Options for this Worksheet
At the bottom of this section there should be a drop box labeled: Gridline Color
Click on the box and select Black as the color.
Don't think the above will solve your problem.
Whenever I color cells, I always have to apply borders
to get the grid lines back.
Not sure there is a solution, except for maybe some VBA code.