My border format automatically changes to pink. I need it black.

Brenda,
Unless your workbook has macros doing this going to
FORMATCELLSBorderColorSelect Automatic should fix your problem,
however you will have to change any previous pink borders manually.


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=570904

The only problem is that the automatic formatting on borers is pink and I
need it to be black.


"Casey" wrote:


Brenda,
Unless your workbook has macros doing this going to
FORMATCELLSBorderColorSelect Automatic should fix your problem,
however you will have to change any previous pink borders manually.


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=570904

Brenda,
One of these procedures should get you what you want.

Apply or remove automatic formatting on a range of cells
1. Select the range you want to format or remove the autoformat from.
2. On the Format menu, click AutoFormat.
3. Do one of the following:
Apply an autoformat Click the format you want. If you want to use
only selected parts of the autoformat, click Options, and then clear
the check boxes for the formats you don't want to apply.
Remove an autoformat At the bottom of the list, click the format
above None.

Create or delete a style
Do one of the following:
Create a new style
1. Select a cell that has the combination of formats you want to
include in the new style. (You can specify the formats when you name
the style.)
2. On the Format menu, click Style.
3. In the Style name box, type a name for the new style.
4. To define and apply the style to the selected cells, click OK.
To define the style without applying it, click Add, and then click
Close.
Specify formats for a style
1. On the Format menu, click Style.
2. In the Style name box, type a name for a new style.
To change formats for an existing style, click the style you want to
change.
3. Click Modify.
4. On any of the tabs in the dialog box, select the formats you want,
and then click OK.
5. Clear the check box for any type of formats that you don't want the
style to include.
6. To define and apply the style to the selected cells, click OK.
To define the style without applying it, click Add, and then click
Close.
Remove a style from selected cells
1. Select the cells that are formatted with the style you want to
remove.
2. On the Format menu, click Style.
3. In the Style name box, click Normal.
Delete a style from the style list
1. On the Format menu, click Style.
2. In the Style name box, click the style you want to delete.
3. Click Delete.
Note You cannot delete the Normal style. If you delete the Currency,
Comma, or Percent style, you won't be able to use the Comma Style ,
Currency Style , or Percent Style button on the Formatting toolbar.

HTH


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=570904