View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Cell borders print default rather than custom setting.

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" wrote in message
...
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