Ask Your Question

Modify existing conditional formatting range in Calc [closed]

asked 2012-11-12 15:32:45 +0200

updated 2015-10-17 15:54:59 +0200

Alex Kemp gravatar image


How can I modify conditional formatting range in Calc? Let's say I have created conditional formatting for cells A1:C4 and I want to expand it for A1:E5.

I know I can save file, unzip it, modify content.xml, zip it up again and load in LO, but this is tiresome.

Alternatively I can select new range of cells and create new conditional formatting with exactly the same conditions. It is sensible workaround if I have only one condition, but is not in case there are few of them.

I am using LO 3.6.3 with redesigned conditional formatting dialog windows.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 15:55:13.818374


m.a.riosv gravatar imagem.a.riosv ( 2012-11-12 22:43:10 +0200 )edit

In LO4.0.0.3 you have 2 options: 1) goto Manage and change the range for the condition. 2) Where you set the contion there is an edit field inthe bottom to change the range.

horst gravatar imagehorst ( 2013-02-05 02:27:03 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2013-01-30 14:46:08 +0200

Format paintbrush, paste special (Ctrl+Alt+V) and manual editing of content.xml are the best ways in LO 3.6.

In LO 4.0 (due to release in February 2013) and later, there is "Edit" button in conditional formatting dialog. You can simply select set of rules, click edit and change range it applies to.

edit flag offensive delete link more


@Mirosław Zalewski -- Sounds like you've figured out an Answer to your question. Please mark your answer as correct. Thanks!

qubit gravatar imagequbit ( 2013-02-24 21:52:20 +0200 )edit

answered 2012-11-12 23:09:12 +0200

JohnSUN: thanks for your answer. However, Format Paintbrush has one drawback - it also applies any direct formatting from source cell to destination cell(s). This makes it not-so-usefull in some user-cases.

But it's good to know that there is another way to do it :) .

edit flag offensive delete link more


Do you combine "conditional formatting" and "direct formatting"? Why? Wherefore?

JohnSUN gravatar imageJohnSUN ( 2012-11-13 08:38:57 +0200 )edit

Let's say we have employee's month schedule. Each row is one employee. In most columns I want to have "time" format, but last column must be "currency" format (this is their payment, premium or whatever, computed on sum of their working hours). I also want conditional formatting on entire table to find out people who have worked more than X and (separately) less than Y.

Mirosław Zalewski gravatar imageMirosław Zalewski ( 2012-11-13 11:20:03 +0200 )edit

Where do you want to use the conditional formatting? At each time cell or at the end when you add up all times for each employee?

ROSt52 gravatar imageROSt52 ( 2012-11-14 09:26:55 +0200 )edit

Let's say: on entire dataset. I want to highlight entire row if condition is met, repeat for each row in set.

Mirosław Zalewski gravatar imageMirosław Zalewski ( 2012-11-14 19:34:25 +0200 )edit

answered 2012-11-12 15:43:28 +0200

JohnSUN gravatar image

updated 2012-11-12 17:04:22 +0200

Try using this tool

Format Paintbrush

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2012-11-12 15:32:45 +0200

Seen: 2,194 times

Last updated: Jan 30 '13