Modify existing conditional formatting range in Calc


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.

Take a look to this bug:

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.

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.

@MirosławZalewski – Sounds like you’ve figured out an Answer to your question. Please mark your answer as correct. Thanks!

Try using this tool

Format Paintbrush

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 :slight_smile: .

Do you combine “conditional formatting” and “direct formatting”? Why? Wherefore?

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.

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?

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