Brian, Dan Thanks so much for these replies, really helpful.
Very glad I joined the support group! All best David On Wed, 10 Jun 2020, 13:44 Dan Lewis, <elderdanle...@gmail.com> wrote: > There is third way to do this using styles. Had you created a style > which described all of the characteristics you want (background AND > text) the particular cell to have, giving other cells involves only two > simple steps: > > 1) Click the cell. > 2) Double click the style. > > If you want to do this to several cells at one time, select the cells > and then double click. > > AOO is designed to use styles to define properties that can be used over > and over again if necessary. This is especially true in Writer when it > simplifies formatting text documents. It is just as true for cells, > rows, columns, and group of cells in Calc. There should be information > in the Calc Guide as to how to do this. > > Dan > > On 6/10/20 06:35, David Deeks wrote: > > Hi all > > > > I am editing a previously created spreadsheet that uses a variety of > colours for background and text. I need to add more cells that use the same > colours. If I select an existing cell, is there a way of identifying the > previously used colours? At the moment I’m selecting all colours that look > close, until I find the right one! > > > > Thanks > > > > David D > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > > For additional commands, e-mail: users-h...@openoffice.apache.org > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > >