Cell borders print default rather than custom setting.

[Phil Hageman]

I have formatted cell borders blue/light weight, which is how they show on
screen. However they print black/standard weight (default). When I go back
to formatting I see the border style set at the default color/weight. Can
someone tell me what is going on here?

Thanks,
Phil

 

[Andibevan]

Have you checked that either the printer settings or that the document
settings within Excel are not set to Black and White?

Andy

 

[Peter T]

Hi Phil,

Even if you have everything setup to print in colour, I think this is a
feature!
I have never found any way to print very thin borders in colour - always
black, at least in my system.
Increase the borders weight though and they will print in colour.

FWIW, things I've tried in the past to no avail -
Change default colour of gridlines in Tools / Options / View / Color
Change various system colours, in particular Windows Text which defines the
automatic colour for borders, (normal gridlines still appear grey)

Regards,
Peter T.

 

[Phil Hageman]

Andibevan and Pete, Thanks for your replies. The answer was to go up to the
next width border and it printed in color - and looked as good as the thin
line too. Problem resolved. You guys have a nice weekend. Regards, Phil