Hylton Conacher (ZR1HPC) wrote: > Hi all, > > Is there a way to copy a particular cells conditional formatting rules > across a cell selection either in a row or a column? > > I have a spreadsheet with three columns of numbers, two of which require > three conditional formatting rules on each and every cell row. > > I know how to increase of the cell reference in a cell formula is > possible, but how can the cell values in the cell conditional formulae > also be updated incrementally? > > If this is not possible, please give me some links as to where I can > suggest it for LibreOffice. This feature is also lacking on MS Excel > 2003 and getting this implemented I am sure would be a MAJOR boost for > LibreOffice. > > Regards > Hylton Hello Hylton
Set up your conditions as required in one cell and confirm they all work as expected. Then you can copy the cell, select paste special and you will get a default of paste all. This will include the conditional formats in my test. Tested using: LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.3.1 openSUSE 11.4 64 bit HTH Regards Dave -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
