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 condit
2011/7/13 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,
> ho
Hylton Conacher (ZR1HPC) wrote:
>
>
> In other words if you copied cell C3 and pasted special on C4:c10, the
> conditional formatting would be copied but the cell references in cell
> C10 for the conditional formatting would point to the same cell as those
> referenced in cell C3.
>
Formulae i
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 refer
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 a