[libreoffice-users] Re: Multuple rules/conditions to range of cells

Am 05.06.2011 18:47, PLO wrote:
> Hello LO Users,
>
>   I've been trying - without success - to apply five separate conditional
>   formatting rule to a column based on their value. Each of the 365 cells in
>   the column contain a simple formula. E.g
>
>   =SUM((N151+L152)-(P152+R152))

Second method is much easier but resticted to the formula cells you 
mentioned.
1. Create your set of cell styles as in the above solution.

2. =SUM((N151+L152)-(P152+R152))+STYLE(VLOOKUP(CURRENT();$X$1:$Y$6;2)
Function STYLE returns zero, so the cell value won't be affected.


--
Unsubscribe instructions: E-mail to users+help@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/www/users/
All messages sent to this list will be publicly archived and cannot be deleted