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