change color of borders for cells doesn't work

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ioan - 24 May 2005 10:51 GMT

This issue occurs at least in Excel 2000 and 2003: select a group of cells,
go in Format/Cells -> Borders and set there some borders and choose a color!
The borders will be set, but not the color. Is this a bug or am I doing
something wrong? Can't find a place at microsoft to make a bug report though.
Cheers,
Ioan.

Reply to this Message

Rob Bovey - 24 May 2005 13:14 GMT

> This issue occurs at least in Excel 2000 and 2003: select a group of
> cells,
[quoted text clipped - 3 lines]
> something wrong? Can't find a place at microsoft to make a bug report
> though.

Hi Ioan,

Make sure to select the color you want before you click the button that
adds the border. Whatever color is selected in the Color dropdown will be
the color of the border you add when you click one of the border buttons. If
you later change the color in the Color dropdown, none of the borders you
have already added will change color.

The preview window in the center of the Format/Cells/Border dialog shows
you how your borders will look. If one of them is the wrong color, simply
select the color you want it to be and click the border button that will add
that border again. You should then see it change to the new color in the
preview window.

Signature

Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

Reply to this Message