hyperlink formatting

[Carrie_Loos via OfficeKB.com]

I have a column, J, that has a mixture of hyperlinks and text or comments. I
want the hyperlink to remain blue with the double underline and the text to
be me default of black but because I have some macros that set up some
formatting all the text in this column ends up blue with double underlines.
Is there a way to set up the entire column with conditional formatting for
anything that has an extension of .pdf it will format with the blue and all
else will be black?

Thanks for any help

 

[bala_vb]

I have a column, J, that has a mixture of hyperlinks and text o
comments. I
want the hyperlink to remain blue with the double underline and th
text to
be me default of black but because I have some macros that set up some
formatting all the text in this column ends up blue with doubl
underlines.
Is there a way to set up the entire column with conditional formattin
for
anything that has an extension of .pdf it will format with the blue an
all
else will be black?

Thanks for any help

try this in conditional formatting to have blue color

=OR(RIGHT($H$6,3)="pdf")

by default black color.

all the bes

 

[Carrie_Loos via OfficeKB.com]

Thanks but it still turns everything in the column to the blue with double
underline - any other ideas?

I have a column, J, that has a mixture of hyperlinks and text o
comments. I

[quoted text clipped - 10 lines]

Thanks for any help

try this in conditional formatting to have blue color

=OR(RIGHT($H$6,3)="pdf")

by default black color.

all the bes