KB202355 - XL2000: Hyperlink Colors Don't Show Expected Color Format

Article ID: 202355

Article Last Modified on 10/7/2003

APPLIES TO

Microsoft Excel 2000 Standard Edition

This article was previously published under Q202355

SYMPTOMS

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

CAUSE

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.

RESOLUTION

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

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.
Select the cell(s) that contain hyperlinks.
On the Format menu, click Style.
In the Style name list, click Hyperlink and click OK to apply the hyperlink style to the selected cells.

STATUS

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

MORE INFORMATION

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:

On the Format menu, click Style.
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.

REFERENCES

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

199738 OFF2000: Hyperlinks Do Not Use Browser-Defined Colors

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.

Additional query words: XL2000

Keywords: kbbug kbweb kbpending KB202355