Page 1 of 1

[Solved] New hyperlinks no longer in color

PostPosted: Thu Dec 05, 2019 3:24 am
by Origdogfish
I have been using hyperlinks to documents in folders on my system. I recently did an accounts payable spreadsheet and included hyperlinks to on-line credit cards. I had to change the selection in hyperlinks to internet. Everything has worked perfectly.

I had to do another spreadsheet and switched back to the document selection in hyperlinks. My new hyperlinks ignore my color settings and only show in black. They are working hyperlinks, though... just the wrong color.

Thanks in advance for your time and attention.
-Jim

PS:
I found that the problem is only with one cell. Creating the same link in a different cell works. If I copy that link into the problem cell it reverts to black as well. Cell format for the prob cell shows "Text and @". Font color is automatic. If nothing else, I can delete the offending line and make a new one.
Thanks
-Jim

Re: New hyperlinks no longer in color

PostPosted: Thu Dec 05, 2019 4:36 am
by Origdogfish
Thanks all... problem solved.

I had other text in the cell I was adding the hyperlink to. I "cut" that and re-entered it. The hyperlink worked fine then. Don't know what the prob was... but that fixed it.
-Jim