Forum Discussion
Saving a color in Excel
I cant figure out why Excel does not save a color chosen from the "More Colors" and keep it saved in "Recent Colors". I have a few colors that are not standard for text and cell fill colors. Each ...
Hi CRW7878 ,
if you use the same custom colors repeatedly, you can create a style. Styles can store number formats, alignment font (including color), border and fill.
Select a cell that has the formatting you want to preserve, then click click the drop-down arrow in the styles gallery and select "New Cell Style". Enter a name for the style.
The next time you would like a cell to be formatted that way, just select the style from the styles gallery.
You can also quickly copy styles between workbooks by copying and pasting styled cells.