Excel formatting colours....

[philg]

As usual, MS Excel (2007) is driving me crazy

I have a nice neatly formatted spreadsheet that contains hyperlinks on some of the cells

I have even managed to turn off the auto underlining of the hyperlinked cells, AND changed the colour of the text :)

BUT, when I save it as an html file, for viewing on the web, the hyperlink colours are NOT what they are in the spreadsheet AND the dratted underlines are back :(

I've fiddled with every formatting option I can think of, but now I am stuck, so if there is an Excel guru out there, I'd appreciate some quick help

Thanks

Phil G

[philg]

OK, some follow up information

From what I can make out in the html source that Excel generates, the colours are EXACTLY how I want them - but neither IE nor Chrome display them the way they are specified.....

Helpppppp

[rojash]

"in the html source that Excel generates, the colours are EXACTLY how I want them - but neither IE nor Chrome display them the way they are specified..... "

I'm surprised that you haven't reached the obvious conclusion. That it has nowt to do with Excel and everything to do with the way Web browsers choose to display hyper-links. You should be able to override this by adding some CSS to the generated html page.

Take a look here:
http://www.goldcoastw...color.shtml#htmlstyle

[philg]

OK, got that

Snag is, using the stylesheet example I CAN change the colours of the hyperlinks, but then I also lose all the for,matting (font, text size, background colour etc) that I had specified in Excel

I think I'll try this in a webpage editor instead

Thanks for your help

Phil G