Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


Hi Hylton,

Hylton Conacher (ZR1HPC) schrieb:
Hi Regina,

See my earlier reply to Dave in addition to the below:.

Copying and writing the conditions are not the problem.

Getting the condition to automatically increment is the problem e.g. I
have cell A1 that has the formula to add the contents of cells B1, C1
and D1. Cell A1 also has 3 conditional formulas that relate its value to
cells B1, C1 and D1 and apply certain colour coding to the A1 cell.

Let see, whether I understand you now.
content of A1 is =B1+C1+D1

Desired condition in A1 is for example: make red if B1 negativ, if not make yellow if C1 negative, if not make green if D1>10.


The formula is cell A1 is the same until cell a10, with just the
respective cell references changing i.e. on cell A5 the formula would
add cells B5, C5 and D5. What I require is that the conditional
formatting applied to cell A1 also be applied to cell A5 but with the
conditional formulae having been incremented i.e. so that the correct
formatting is shown, as per the conditional formulae for the values on
that row i.e. b5, C5 and D5, when the value in A5 is compared to cells
B5, C5 and D5.

If you use relative addresses in your condition, the condition is adapted when copied same as the cell formulas.

Example:
Condition for A1 is
1.condition: "Formula is" =B1<0
2.Condition: "Formula is" =C1<0
3.Condition: "Formula is" =D1>10

When you now copy this condition to A8, you will get for A8 the condition
1.condition: "Formula is" =B8<0
2.Condition: "Formula is" =C8<0
3.Condition: "Formula is" =D8>10

It that, what you are looking for?

Kind regards
Regina


--
Unsubscribe instructions: E-mail to users+help@global.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/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.