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. Excel displays a small palette of colors and some other options. (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.