Changing Hyperlink Properties

[icetrey]

I have several cells with text in each that I have made into a hyperlink. Hyperlinks, by default, will change shape and color when clicked. I would like for the text to keep it's original formatting when clicked. Is thier a way to lock the formatting or adjust the hyperlink properties so that it is the same as the text formatting? I also don't want to lose any conditional formatting that I have for that cell.

[Leith Ross]

Hello Icetrey,

The Hyperlink object has no formatting properties. What you see is what you get.

Sincerely,
Leith Ross

[starguy]

I have several cells with text in each that I have made into a hyperlink. Hyperlinks, by default, will change shape and color when clicked. I would like for the text to keep it's original formatting when clicked. Is thier a way to lock the formatting or adjust the hyperlink properties so that it is the same as the text formatting? I also don't want to lose any conditional formatting that I have for that cell.

Hi
Select cell with hyperlink (with arrow keys or with mouse), for selecting with mouse hover over that cell and click the left mouse button and keep it pressed for a while it will select that cell. Now change its font colour to your required colour and remove underline formatting.

Click that cell and see the formatting...