Re: How to convert RGB decimal to RGB hex and vise versa in Excel sheets?

You are using .xls. I don't know the details of the file format, but that was for Excel 2003 & earlier. These versions of Excel had an internal colour palette of 56 colours. Any colour was assigned to the member of the palette that was closest. So you may be seeing some assignment to an assumed palette. This is only a guess as I do my manipulation of Excel either directly in VBA or via Win32::OLE.

Regards,

John Davies

Comment on Re: How to convert RGB decimal to RGB hex and vise versa in Excel sheets?

Replies are listed 'Best First'.
Re^2: How to convert RGB decimal to RGB hex and vise versa in Excel sheets? by thanos1983 (Parson) on Apr 21, 2017 at 08:15 UTC
Hello davies, Thanks for the reply, but it sounds a bit strange that only accepts RGB int and the RGB hex does not work. Well I guess there I will continue experimentation just in case that I will come up with a solution. Thanks again for your time. Seeking for Perl wisdom...on the process of learning...not there...yet!	[reply] [d/l] [select]