View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.setup
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default 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 -