Reporting services knowing how a colour will appear in excel export

I have been playing around with some reports and exporting them to excel, only to find that the colour in SSRS is not even remote开发者_如何学Cly close to that in excel - for example if I have a textbox that is PaleGreen is SSRS, it comes out a rather unpleasant shade of grey.

Is there a way of knowing which SSRS colours will look the same in excel exports so I can stick to those? I'm using SSRS 2005 and excel 2003 (but can use Excel 2007 if it helps).

Thanks!

---

Seems to be excel 2003 limited palete problem.

A workaround could be:

Open excel 2003, choose a color and check it's RGB values, and convert them to HEX

In reporting services use the HEX value as background color.

You can find an online DEC to HEX converter here: http://www.mathsisfun.com/binary-decimal-hexadecimal-converter.html

---

Sounds like this is caused by the algorithm that is used to match the reporting services colors up to the excel color pallet. There is no fix for this. I usually tend to try to use basic colors Silver, White, Blue, etc. to avoid these issues.

http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/c592e7ac-84a4-4dc1-9c82-bd1657e7a9b4