View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carrie_Loos via OfficeKB.com Carrie_Loos via OfficeKB.com is offline
external usenet poster
 
Posts: 116
Default 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