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.