Invoked the same way as the getRGB1 macro, this version returns a string such as 'R=255, G=204, B=0'. If you want to get the decimal values for each of the colors, then the following macro returns that: You may not want the traditional hex codes for the RGB colors, however. To use the function you simply invoke it, in your worksheet, with a cell referenced in this manner: This macro looks at the interior color for any cell you reference, puts the hex values for the color in the right order, and returns the string to Excel. GetRGB1 = Right(sColor, 2) & Mid(sColor, 3, 2) & Left(sColor, 2) For instance, if you want to have the traditional six-character hex code for RGB colors returned, you would use the following very simple macro: The function you use depends on what you want to actually have returned to your worksheet. If you have a need to get the values more often, then creating your own user-defined function is the way to go. At the bottom of the dialog box you can see the individual values for the red, green, and blue components of the color in the cell.Make sure the Custom tab is displayed.Excel displays a small palette of colors and some other options.

Click the down-arrow at the right side of the Fill Color tool, in the Font group.Select the cell that is formatted with the color you want to check.(Neil wants the actual color applied to the cell, not any 'override' color, such as one imposed by a conditional format.)Įxcel doesn't include a function to do this, but if you only need to check out the RGB values for a single cell, the easiest way is to follow these steps: He wonders if there is a way to return (via function or macro) the RGB value of the color used to fill a cell. Neil would like to do the opposite-determine an RGB value. He knows that he can generate a color based upon a numeric RGB value (as explained in other ExcelTips issues). Neil uses colors a lot in his worksheets.

Color index codes for mac excel