Set the cell color to any RGB or HEX value

[Rick]

Is it possible to set the cell color to any RGB value or HEX values (such as 176-196-222 or
"b0c4de") within the Format Cells dialog. If I do it via VBA it will refresh at each startup?
....and necessitate resetting all of the cell colors again?

What I am trying to do is provide (what I think) is a mellow background for the entire
worksheet...and of course there will be other cells with other colors that will get in the way.

Rick

 

[JE McGimpsey]

XL can only display 56 colors at a time. The colors are in the color
palette (tools/options/color). If you use VBA to enter an RGB value or
use the RGB function, XL will pick the "closest" match within the
existing table.

You can modify the table for any particular workbook - just click modify
in the tools/options/color dialog. Your new color table will be saved
with your workbook for future display.