Convert a list of RGB values to CMYK

jdonnelly

New Member
Joined
Aug 18, 2014
Messages
2
I have a list of RGB values that I would like to convert to CMYK values. I've located some help that will requires the values be entered manually. I would like to read the list and convert.

Thanks!
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,878
Office Version
  1. 2010
Platform
  1. Windows
Can you tell us where your RGB values are located and tell us where you want the CYMK values to be placed and whether you want a formula solution or VBA solution?
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,878
Office Version
  1. 2010
Platform
  1. Windows
Where did you go? You were online when I asked my question. Okay, I'll assume your RGB values are in separate columns (Columns A, B, C for R, G, B respectively) and that your output is to go in Columns D, E, F, G (for C, M, Y, K respectively). Also, I am assuming Row 1 is used for headers. With that said, put these formulas in the indicated cells and copy them down...

D2: =(1-$G2-A2/255)/(1-$G2)

E2: =(1-$G2-B2/255)/(1-$G2)

F2: =(1-$G2-C2/255)/(1-$G2)

G2: =1-MAX(A2/255,B2/255,C2/255)

Make sure to format the cells in Columns D, E, F, G as Percentage with zero decimal points.
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,943
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Rick, we need to prevent to prevent #DIV/0 errors for black, that is, RGB(0, 0, 0). It might be as simple as

D2: =(1-$G2-A2/255)/(1-IF($G2=1,0,$G2))
E2: =(1-$G2-B2/255)/(1-IF($G2=1,0,$G2))
F2: =(1-$G2-C2/255)/(1-IF($G2=1,0,$G2))
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,878
Office Version
  1. 2010
Platform
  1. Windows

ADVERTISEMENT

Good catch Jon. If I had noticed that problem, I probably would have opted to use IFERROR...

D2: =IFERROR((1-$G2-A2/255)/(1-$G2),)
E2: =IFERROR((1-$G2-B2/255)/(1-$G2),)
F2: =IFERROR((1-$G2-C2/255)/(1-$G2),)
 

jdonnelly

New Member
Joined
Aug 18, 2014
Messages
2
Rick and Jon, Thank you both for your assistance with this issue. Rick, you assumptions regarding how the columns are setup are correct. We now have a solution in place for this challenge.

Thanks!
 

Watch MrExcel Video

Forum statistics

Threads
1,127,613
Messages
5,625,848
Members
416,139
Latest member
MattBoard

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top