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 [email protected]
In case of problems unsubscribing, write to [email protected]
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
