i'm trying to get colors outside the 56 color palette as fill and while i can manually select them from a color wheel, i can't enter the RGB values i desire. i believe there is an RGB function of some sort that takes three arguments for the three color values but i can't get the PATTERNS() function to recognize it.

in the general forum i was asking for ways to modify the 56 color palette as another approach but so far the only tip i've gotten is the Compatibility subscreen of Preferences which seems to provide the function but only relative to older excel documents. i can't find how you modify the color palette of the current workspace.

thanks for any colorful ideas.

brian