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

Am 06.06.2011 15:12, Michael D. Setzer II wrote:
> I've tried another method that seems to give the results.
> Unfortunately, it appears the current() doesn't give the results of
> what is before the style when used in a formula?

Difficult to tell without concrete formula.


> =(A1)+STYLE(CHOOSE(MIN(INT(((A1)-((A1)
> > 1000))/1000)+1,6),"Red_bold","red","blue_bold","blue","orange","default"))
>
> I used a single cell for the formula, but the (A1) could be replaced
> with the formula (SUM((N151+L152)-(P152+R152))) or
> (N151+L152-P152-R152) to give the same results.
>
> Would have been simpler if all the options where<  multiples of
> 1000 or all<=. I also added max and min, so a negative or higher
> value would fall into the ranges.
>
> I created styles with the matching names giving the styles.

Looking up the style name has 2 advantages: You can easily modify the 
style names in the stylist and in the lookup table and you can modify 
the threshold values in one place for all calculations including 
conditional formattings. Quite often such a lookup table includes more 
than 2 columns. Finding all occurrences of a particular format conditon 
can be difficult.


--
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