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

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.

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.

I trust that answers the query.

Regards
Hylton
-- 
========================================================================
Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A)
http://www.fishhoeklionsclub.org.za being part of the worlds largest NGO
========================================================================

-- 
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