Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do you make Excel use CMY colors instead of RGB colors?
How do you make Excel use CMY colors (to match my printer) instead of RGB
colors? -- Jim Benet |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do you make Excel use CMY colors instead of RGB colors?
What are you trying to do? Maybe if you describe your goal, someone
here can provide a method better suited to the task. --JP On Oct 5, 8:05*pm, Jim Benet wrote: How do you make Excel use CMY colors (to match my printer) instead of RGB colors? -- Jim Benet |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do you make Excel use CMY colors instead of RGB colors?
I used cell background colors (ie., fill colors) on my spread sheet. I
printed the sheet out on my Epson printer, but the colors where not exactly the same. In the case of the yellow, they were way off. I know that the printer uses CMY colors and Excel uses RGB colors. My question was how do you make Excel use CMY colors instead of RGB. My goal is to make the colors match. -- Jim Benet "JP" wrote: What are you trying to do? Maybe if you describe your goal, someone here can provide a method better suited to the task. --JP On Oct 5, 8:05 pm, Jim Benet wrote: How do you make Excel use CMY colors (to match my printer) instead of RGB colors? -- Jim Benet |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do you make Excel use CMY colors instead of RGB colors?
I don't think there is a direct way, but I found a converter on this
site: http://local.wasp.uwa.edu.au/~pbourk...olour/convert/ Red = 1 - Cyan Green = 1 - Magenta Blue = 1 - Yellow So with your known CMY values, we can write a user defined function that converts them to the RGB values you want, which you can use to adjust the color selection for your filled cells. Function ConvertToRGB(iCyan As Integer, iMagenta As Integer, iYellow As Integer) As String Dim iRed As Integer, iGreen As Integer, iBlue As Integer iRed = 1 - iCyan iGreen = 1 - iMagenta iBlue = 1 - iYellow ConvertToRGB = iRed & ", " & iGreen & ", " & iBlue End Function I'm not familiar with CMY values so if the results are not what you expect, you should be able to tweak it appropriately. Let me know if you need to know how to use the function. --JP On Oct 6, 4:08*pm, Jim Benet wrote: I used cell background colors (ie., fill colors) on my spread sheet. *I printed the sheet out on my Epson printer, but the colors where not exactly the same. *In the case of the yellow, they were way off. *I know that the printer uses CMY colors and Excel uses RGB colors. *My question was how do you make Excel use CMY colors instead of RGB. *My goal is to make the colors match. -- Jim Benet "JP" wrote: What are you trying to do? Maybe if you describe your goal, someone here can provide a method better suited to the task. --JP On Oct 5, 8:05 pm, Jim Benet wrote: How do you make Excel use CMY colors (to match my printer) instead of RGB colors? -- Jim Benet- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do you make Excel use CMY colors instead of RGB colors?
Thanks, JP. I think the "1"s should actually be 255, since the color scale
goes from 0 to 255 for each color. Also, I believe the color palettes of CMY are not the same as RGB because they combine differently on the printer. So the math functions you gave are only approximate. For example, there could be combinations of RGB and can never be duplicated in the CMY palette and visa versa. That is why I was looking for a set up function in Excel that would change the color palette to CMY-based. Thanks again for researching this for me. -- Jim Benet "JP" wrote: I don't think there is a direct way, but I found a converter on this site: http://local.wasp.uwa.edu.au/~pbourk...olour/convert/ Red = 1 - Cyan Green = 1 - Magenta Blue = 1 - Yellow So with your known CMY values, we can write a user defined function that converts them to the RGB values you want, which you can use to adjust the color selection for your filled cells. Function ConvertToRGB(iCyan As Integer, iMagenta As Integer, iYellow As Integer) As String Dim iRed As Integer, iGreen As Integer, iBlue As Integer iRed = 1 - iCyan iGreen = 1 - iMagenta iBlue = 1 - iYellow ConvertToRGB = iRed & ", " & iGreen & ", " & iBlue End Function I'm not familiar with CMY values so if the results are not what you expect, you should be able to tweak it appropriately. Let me know if you need to know how to use the function. --JP On Oct 6, 4:08 pm, Jim Benet wrote: I used cell background colors (ie., fill colors) on my spread sheet. I printed the sheet out on my Epson printer, but the colors where not exactly the same. In the case of the yellow, they were way off. I know that the printer uses CMY colors and Excel uses RGB colors. My question was how do you make Excel use CMY colors instead of RGB. My goal is to make the colors match. -- Jim Benet "JP" wrote: What are you trying to do? Maybe if you describe your goal, someone here can provide a method better suited to the task. --JP On Oct 5, 8:05 pm, Jim Benet wrote: How do you make Excel use CMY colors (to match my printer) instead of RGB colors? -- Jim Benet- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do you make Excel use CMY colors instead of RGB colors?
It was just a guess, I just assumed that the information on that page
is correct. I know it's possible but wasn't sure exactly how to do it. Feel free to tweak the algorithm until it produces the output you want. --JP On Oct 7, 4:31*pm, Jim Benet wrote: Thanks, JP. *I think the "1"s should actually be 255, since the color scale goes from 0 to 255 for each color. Also, I believe the color palettes of CMY are not the same as RGB because they combine differently on the printer. *So the math functions you gave are only approximate. *For example, there could be combinations of RGB and can never be duplicated in the CMY palette and visa versa. *That is why I was looking for a set up function in Excel that would change the color palette to CMY-based. * Thanks again for researching this for me. -- Jim Benet "JP" wrote: I don't think there is a direct way, but I found a converter on this site: http://local.wasp.uwa.edu.au/~pbourk...olour/convert/ Red = 1 - Cyan Green = 1 - Magenta Blue = 1 - Yellow So with your known CMY values, we can write a user defined function that converts them to the RGB values you want, which you can use to adjust the color selection for your filled cells. Function ConvertToRGB(iCyan As Integer, iMagenta As Integer, iYellow As Integer) As String Dim iRed As Integer, iGreen As Integer, iBlue As Integer * iRed = 1 - iCyan * iGreen = 1 - iMagenta * iBlue = 1 - iYellow * ConvertToRGB = iRed & ", " & iGreen & ", " & iBlue End Function I'm not familiar with CMY values so if the results are not what you expect, you should be able to tweak it appropriately. Let me know if you need to know how to use the function. --JP On Oct 6, 4:08 pm, Jim Benet wrote: I used cell background colors (ie., fill colors) on my spread sheet. *I printed the sheet out on my Epson printer, but the colors where not exactly the same. *In the case of the yellow, they were way off. *I know that the printer uses CMY colors and Excel uses RGB colors. *My question was how do you make Excel use CMY colors instead of RGB. *My goal is to make the colors match. -- Jim Benet "JP" wrote: What are you trying to do? Maybe if you describe your goal, someone here can provide a method better suited to the task. --JP On Oct 5, 8:05 pm, Jim Benet wrote: How do you make Excel use CMY colors (to match my printer) instead of RGB colors? -- Jim Benet- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Used drawing colors in shapes....lost default colors for "Fill Col | Excel Discussion (Misc queries) | |||
excel 2007 colors do not match excel 2003 colors. | Excel Discussion (Misc queries) | |||
Worksheet formatting (fill colors & text colors) disappeared | Excel Discussion (Misc queries) | |||
Lost highlighting and font colors; background colors on web pages | Excel Discussion (Misc queries) | |||
How do I make colors appear correctly when linking excel to pub? | Excel Discussion (Misc queries) |