hyperlink formatting
 

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

--
Message posted via http://www.officekb.com

try this in conditional formatting to have blue color

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

by default black color.

all the best

hyperlink formatting
 

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

bala_vb wrote:
Carrie_Loos via OfficeKB.com;955803 Wrote:
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

--
bala_vb

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201005/1