I want change color of one hyperlink if it had linked with one PDF to RED and if had not link with one PDF will show BLUE color.
Pls help me as soon as possible.
Thanks and Best regards.
Normally, when we click the hyperlink in a worksheet, the blue color hyperlink will be changed to purple as following screenshots shown. But sometimes, we just want to keep hyperlink are blue color whenever we click it or not. How could we prevent hyperlink from changing color after we click it?
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
To keep the hyperlink without changing color after clicking it, please do as these:
1. Go to click Page Layout tab in the ribbon, and then click Colors > Create New Theme Colors, see screenshot:
2. And in the Create New Theme Colors dialog, in the Theme colors section, click the drop down list beside the Followed Hyperlink option, and choose the blue color of the original hyperlink color. See screenshot:
3. At last, click Save button to save this setting. When you click the hyperlink next time, the color of it will not be changed.