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

Reply via email to