Change the appearance of hyperlink text
You can change the appearance of all hyperlink text in the current workbook by changing the cell style for hyperlinks.
On the Home tab, in the Styles group, click Cell Styles.
Under Data and Model, do the following:
To change the appearance of hyperlinks that were not clicked, right-click Hyperlink, and then click Modify.
To change the appearance of hyperlinks that were clicked, right-click Followed Hyperlink, and then click Modify.
Note: The Hyperlink cell style is available only when the workbook contains at least one hyperlink. The Followed Hyperlink cell style is available only when the workbook contains a hyperlink that was clicked.
In the Style dialog box, click Format.
On the Font tab and Fill tab, select the formatting options that you want, and then click OK.
Notes:
The options that you select in the Format Cells dialog box appear as selected under Style includes in the Style dialog box. You can clear the check boxes for any options that you don't want to apply.
Changes that you make to the Hyperlink and Followed Hyperlink cell styles apply to all hyperlinks in the current workbook. You can't change the appearance of individual hyperlinks.
