Excel only supports 56 colors in the worksheets (fonts and backgrounds).
If you assign an RGB color that doesn't match, Excel will use the available
color closest to it. You can alter the 56 colors by editing them in
Tools=Options=Color tab. This custom pallete will be stored with the
workbook.

David McRitchie has a page on colors in Excel that you might want to look
at:

http://www.mvps.org/dmcritchie/excel/colors.htm

--
Regards,
Tom Ogilvy

"AlexT" wrote in message
oups.com...
Folks...

I need to write some code that would set the background color of a cell
to a custom value based on a Pantone color...

So I will probably need to get some RGB approximation and apply it to
the cell.

As I'd hate to reinvent the wheel I'm just asking around here.

:)

Regards

--alexT