Re: [libreoffice-users] Re: Conditional formatting cell copying?

2011-07-13 Thread Hylton Conacher (ZR1HPC)
Hi Dave, Thanks for the answer, and sorry for the belated reply, however it doesn't work using LibreOffice 3.3.1 OOO330m19 (Build:8) tag libreoffice-3.3.1.2 On OpenSuse 11.0 You are quite correct that the conditional formulae are copied too, however the formulae still refer to the same cell

Re: [libreoffice-users] Re: Conditional formatting cell copying?

2011-07-13 Thread Johnny Rosenberg
2011/7/13 Hylton Conacher (ZR1HPC) hyl...@conacher.co.za: Hi Dave, Thanks for the answer, and sorry for the belated reply, however it doesn't work using LibreOffice 3.3.1 OOO330m19 (Build:8) tag libreoffice-3.3.1.2 On OpenSuse 11.0 You are quite correct that the conditional formulae are

Re: [libreoffice-users] Re: Conditional formatting cell copying?

2011-07-13 Thread jorge
Hi You can do it like this: 1) Select two columns and all rows that you need format. 2) Select Menu-Format-Conditional Format 3) Make the format that you need 4) Accept I know that this conditional format is for all area selected and it didn't show a special cell formula o

[libreoffice-users] Re: Conditional formatting cell copying?

2011-07-12 Thread Dave Griffiths
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