Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there any way of changing the range of conditional formatting in LibreOffice Calc (version 3.6)? I have a set applied already to a range of cells, but there is no obvious way of changing which cells a given set of conditional formatting is applied to. I either have to copy and paste the formatting, which results in multiple entries in the conditional formatting (which makes it difficult to manage), or delete the entire thing and create a new one every single time I want to change the range of cells.

Is there a better way?

Cell range formatting

share|improve this question
Have you tried using the format painter? I don't know if it would help. – Dennis Williamson Feb 3 '14 at 8:03

Cant you put a large area to your range?

Try to tag the whole sheet and add a new conditional format.
The range will be A1:ZX9999999 or so.

share|improve this answer
Well, I don't want it applied to the whole sheet. If I did it that way, I'd have to add additional logic to each rule to limit the range, which is a bit of a hassle. Every single rule would need to be wrapped in loads of additional logic just to limit the range to which it is being applied. – Simon Lundberg Sep 11 '12 at 10:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.