Need Help Using "Color Calculations in Excel - RGBCMYK" Macro

[Jimz59]

Hello everyone,

I hope you're doing well. I'm currently working on an Excel project that involves color calculations, and I came across a macro called "Color Calculations in Excel - RGBCMYK" which seems perfect for my needs. However, I'm facing some difficulties in utilizing all the macros properly.

First and foremost, I must admit that I'm not very experienced with Excel macros, so I might be missing some crucial steps in the process. I've tried following the instructions provided with the macro, but it's still not working as expected

I've searched extensively for troubleshooting tips or tutorials online, but unfortunately, I haven't found any comprehensive resources for this particular macro. As a result, I'm feeling a bit stuck and unable to make progress on my project.

If any of you have experience using the "Color Calculations in Excel - RGBCMYK" macro or are familiar with Excel macros in general, I would be incredibly grateful for your guidance. 7

Additionally, if you have alternative suggestions for achieving color calculations in Excel, I'm open to exploring different approaches as well.

Thank you so much for your time and assistance.


Best regards,

Jimz59 (FR)

 

[davesexcel]

Hello,
How does your color calculations work?

 

[Jimz59]

Hello,
How does your color calculations work?

The topic concerns wavelength reflection, and various calculations are employed to convert it between CIE XYZ, CIE LAB, or CIE LCH color spaces. To explore the subject in more detail, you can refer to the following link: General Color Terms | Konica Minolta Sensing.

Among these conversions, there is one that involves converting CIE LAB* to CIE LCH.

Instead of performing the conversion manually, I am interested in using a macro to streamline and expedite the process. This would allow for faster and easier calculations.

 

[Jimz59]

For DL the maccro : ColorTools | Home - rgbcmyk

 

[davesexcel]

That's above my pay grade but thanks for supply the links so others can check it out.

Would you be able to supply a simple sample workbook as well?
You would have to supply a link, via google drive, one drive....

 

[Jimz59]

yes of course, Help Using Color Calculations in Excel - RGBCMYKMacro