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

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 condition... It looks transparent.

Regards,

Jorge Rodríguez
_______________



El mié, 13-07-2011 a las 21:04 +0200, Hylton Conacher (ZR1HPC) escribió:
> 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 references given in
> the copied cell.
>
> 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.
>
> Please confirm if this is the case.
>
> Regards
> Hylton
> -- 
> ========================================================================
> Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A)
> http://www.fishhoeklionsclub.org.za being part of the worlds largest NGO
> ========================================================================

-- 
Atentamente,

Jorge Rodríguez


-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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