no grid lines when cells are coloured

[paul]

when i change the colour of a set of cells, the grid lines no longer
appear in the coloured cells. am i able to both coloured cells and
grid lines

 

[Nick Hodge]

Paul

The gridlines you talk of are the built in 'guides' which are overwritten
when you apply a cell 'fill'. The way over this is to apply a 'border' to
the coloured cells.

Format>Cells...>Border

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Gord Dibben]

Paul

You cannot have colored cells and gridlines. The colored cells overlap the
gridlines and make them invisible.

Investigate the use of Format>Cells>Borders.

Gord Dibben Excel MVP