XL2000: Hyperlink Colors Don't Show Expected Color Format

Hyperlinks in your workbook, whether followed or unfollowed, may be formatted with an unexpected color and underline.

This problem occurs when you do the following:

�	You select a cell that contains a hyperlink. -and-
�	You delete either the Hyperlink or Followed Hyperlink style.

If you delete the Hyperlink or Followed Hyperlink style, you can reapply the style to reformat the cell. To do this, follow these steps:

1.	Insert a new hyperlink into your worksheet. Click the hyperlink. This step is necessary because it adds back the deleted Hyperlinks and Followed Hyperlinks styles.
2.	Select the cell(s) that contain hyperlinks.
3.	On the Format menu, click Style.
4.	In the Style name list, click Hyperlink and click OK to apply the hyperlink style to the selected cells.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

The Hyperlink style controls the appearance of hyperlinks that have not been clicked. The Followed Hyperlink style controls the appearance of hyperlinks that have been clicked. To change the appearance of hyperlinks, follow these steps:

1.	On the Format menu, click Style.
2.	In the Style name list, click Hyperlink or Followed Hyperlink, and then click Modify.

Anytime you select one or more cells and click OK in the Style dialog box, Excel applies the style that appears in the Style name list to the selected cells. When a style has been applied to a selected cell, and you delete that style, Excel applies the Normal style to that cell.

For additional information about hyperlinks, please see the following article in the Microsoft Knowledge Base:

For more information about hyperlink styles, click Microsoft Excel Help on the Help menu, type Change the appearance of hyperlink text in the Office Assistant or the Answer Wizard, and then click Search to view the topic.