On 6 Jun 2011 at 21:59, Andreas Säger wrote: To: users@libreoffice.org From: Andreas Säger <ville...@t-online.de> Subject: [libreoffice-users] Re: Multuple rules/conditions to range of cells Date sent: Mon, 06 Jun 2011 21:59:48 +0200 Send reply to: users@libreoffice.org
> 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. I had an earlier formula that was working using the reference to a cell like A1, but when I replaced that with current(), it did not work correctly. I assuming that since the current() was inside the other functions that it was giving some other value. The lookup options is also something I've used, and it is very useful, but just another option that is available. > > > > =(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+h...@libreoffice.org > In case of problems unsubscribing, write to postmas...@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 +----------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mi...@kuentos.guam.net mailto:msetze...@gmail.com http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +----------------------------------------------------------+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS SETI 10840698.799905 | EINSTEIN 5978952.530851 ROSETTA 3215702.700203 | ABC 6158864.767707 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@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