Re: [libreoffice-users] Conditional formatting cell copying?

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