On 6 Jun 2011 at 21:59, Andreas Säger wrote:
To: users@libreoffice.org
From: Andreas Säger
Subject:[libreoffice-users] Re: Multuple rules/conditions to
range of cells
Date sent: Mon, 06 Jun 2011 21:59:48 +0200
Send reply to
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
On 6 Jun 2011 at 10:55, Andreas Säger wrote:
To: users@libreoffice.org
From: Andreas Säger
Subject: [libreoffice-users] Re: Multuple rules/conditions to
range of cells
Date sent: Mon, 06 Jun 2011 10:55:43 +0200
Send reply to: users@libreoffice.org
> Am 05.06.2011 18:47, PLO wrote:
> >
Hello Andreas,
On Mon, 06 Jun 2011 11:00:26 +0200 (your time) you said:
> 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)
> Func
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 m
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))
I need the result