Hi Gerry,

you can work wit cell templates. Therefor open the template dialog by using function key F11 and create a new one by pressing the right mouse button ontop of this dialog. Then select the "New" link. Hint: Assinging a name to this template helps...

The function you want to use then is the water can button where you can assign multiple cells with all that formating defined within the cell template.

Otherwise (without using templates) you could also multi select all those cells there you want to change the colour and then assign the background colour at once. In the icon bar you find a button for background color. Press it once and then select the dialog title and drag it somewhere else (select the title and hold down the right mouse button)

Using templates is a very powerful tool as it allows you to work with inheritance of templates so a child template can inherit objects of it's mother template. And cell templates can be exported to an other document, so you can easily create a template library.

Based upon the usage of cell templates it's quite easy to use the feature of conditional formatting (Format menu)

Kind regards, Joost


Am 20.03.2020 um 16:19 schrieb Gerry Woodard:
I would like to not have the color table change to the cell color when
selected. I would prefer that the color selection indicator remain fixed
until needed. For example, if I want to change several cells from red to
black, need only select black once from the table, Hope this is clear.
Thanks.
Jerry Woodard
*.* “Energy and persistence conquer all things.”* – Benjamin Franklin*
* “Make America Great Again.” - Donald Trump*




---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Reply via email to