Spreadsheets

Hi Lorraine, thanks for your query. You'll need to set the formatting of the hyperlink which you do like this:

1. On the Design tab, in the Themes group, click Colors, and then click Create New Theme Colors.

2. In the Create New Theme Colors dialog box, under Theme colors, do one of the following:

To change the color of hyperlink text, click the arrow next to Hyperlink, and then select a color.

To change the color of followed hyperlink (followed hyperlink: A hyperlink to a destination you have visited. Once you follow a hyperlink to its destination, the hyperlink changes color.) text, click the arrow next to Followed Hyperlink, and then select a color.

3. Click Save.

Hope this helps,

Anthony