ExcelBanter - Changing several cells text color

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Changing several cells text color (https://www.excelbanter.com/excel-discussion-misc-queries/134475-changing-several-cells-text-color.html)

Changing several cells text color

Can you automaticall change several differents cells text? I have Publisher
and they have a color scheme where you select a color from a set of 6
different colors and if you change one of the colors, any text with that
color changes to the new color. Does excel have anything like this or a
formula that will do this?
--
Thanks,
Laura

Changing several cells text color

XL allows up to 56 colors in the Color Palette. By changing the color in
the palette, any text with that color will also change. Choose
Tools/Options/Color, select the color of your text and click Modify,
then change the color as needed.

In article ,
lauras03 wrote:

Can you automaticall change several differents cells text? I have Publisher
and they have a color scheme where you select a color from a set of 6
different colors and if you change one of the colors, any text with that
color changes to the new color. Does excel have anything like this or a
formula that will do this?