Hyperlink formatting

[Esradekan]

Can anyone help me with this. I have some hyperlinks in my workbook, hyperlinks to other pages in the workbook. I want those hyperlinks to appear inthe cell format colouring and not change to the default 'blue' format for hyperlinks. Can this be done does anyone know?

Thanks for help.

(^-^)<

Esra

 

[ak440031]

Hi Esradekan,

For coloring your hyperlink you need to follow these steps

Step 1: Create a hyperlink in a cell let's say www.google.com

Step 2: Right click the Cell and select 'Format Cells' option

Step 3: Select the Font tab, and change the color.

With Thanks,
Anoop Kumar.V

For more excel answeres visit : http://excelautomate.blogspot.in/