2 Questions on Changing the Color of Worksheets

1. Hold the CTRL key and click on multiple tabs to select multiple sheets. Any change to data, formulas, or formatting on the visible sheet will also be applied to all the selected sheets in the corresponding cells.

2. You can, of course, change the font color of the individual link. As for the default, I no longer have 2003 but you might want to try the advice from this page:

Originally Posted by JohnWilson

Format > Style and in the name dropdown choose hyperlink / followed hyperlink and > modify. You should be able to change the colour

Select the sheets as a group. Hold down the CTRL key then select the sheets in question. After you've made the selections release the CTRL key. Look in the title bar and you'll see something like this: [Group]

Then, make the changes as desired. What you do on one sheet will be applied to all of the grouped sheets. After you're done make sure to ungroup the sheets. One way to do that is to select any sheet that is not included in the group.

To change the color of a hyperlink...

Select the cell with the hyperlink
Goto the menu Format>Style
From the drop down list select Hyperlink
Click the Modify button
Make your changes

You're welcome!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.