How can I change dafault color in excel from black to another?

[motyka]

For example - the default border color is black. Can I chnge it to red?

 

[Biff]

Hi!

You would have to change the default color of the gridlines then the format
borders default color will also change.

Tools>Options>View

Check Gridlines then select a color from the drop down.

Biff

 

[motyka]

Thanks! But can I now change the pattern of grid's borders. Now it
isn't solid !!!!
R.M.

 

[GRM via OfficeKB.com]

For example - the default border color is black. Can I chnge it to red?

Try Format Style Modify Borders select Red, click Outline ok

Geoff

 

[Biff]

Hi!

The only way that I know of is to format the range of cells and then select
the border style you want.

I guess you could have a Workbook_Open event macro to do this but I can't
help with that.

Biff

 

[motyka]

Yes. But in this case I have already selected borders in border tab. I
don't want it! Meybe should I it in registry change?