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
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
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)
Function
On 6 Jun 2011 at 10:55, 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 10:55:43 +0200
Send reply to: users@libreoffice.org
Am 05.06.2011 18:47, PLO
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