(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.
