MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Nothing for colorblinds... ;-)

Posted by Lukas on November 14, 2001 1:44 PM


In graphic programs I can define colors by their RGB numbers... I wanna format my excel-chart with some specific colors... Is there a possibility to define the colors like in a graphic program?

thanx a lot


Posted by Juan Pablo on November 14, 2001 1:50 PM

In Excel you also can specify the color using RGB, for example...

ActiveCell.Interior.Color = RGB(253,143,74)

Applies to other objects as well.

Juan Pablo

Posted by Lukas Weder on November 14, 2001 2:13 PM


but in "format chart area" tab "patterns" I have just this little selection of colors... how can I edit this colors? (I don't wanna use vb)... Is there a way?

thanx again! Lucky

Posted by Mark W. on November 14, 2001 4:13 PM

Choose the Tools | Options... menu command and
select the Color tab. Default "Chart fills" and
and "Chart lines" are shown. Select the color
that you wish to change, press [ Modify ], and
choose the "Custom" tab. You can adjust RGB
values and then press [ OK ]. You may want to
tweak the values on a clean workbook and save
it as a template or set it aside as a standard
configuration in case a given workbook's colors
are inadvertantly reset. Custom colors can be
re-established on a reset workbook by selecting
an open workbook name using the "Copy colors from"
drop down list.