Ask Your Question

prioritize overlapping conditional format? [closed]

asked 2014-05-06 16:07:16 +0200

myhairisspikey gravatar image

updated 2015-09-06 20:35:24 +0200

Alex Kemp gravatar image

Hey I'm using LibreOffice on Ubuntu 14.04. I am trying to figure out how to prioritize or apply one conditional formatting after another.

For example, I have one rule that adds a background color to every odd number row in my worksheet. I also have a rule that says any blank cell within a set of columns apply a red background color. The problem is the odd number highlighting happens to applied later so only the white rows have the red background color applied.

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 2016-02-22 15:35:09.302563

3 Answers

Sort by » oldest newest most voted

answered 2014-05-10 08:55:53 +0200

myhairisspikey gravatar image

I think I have got it now... but it's not quite the solution I wanted. I guess libreoffice prioritizes the rules in the order you add them.

So I created 1 rule for the red background blank cells first and then the grey background for the odd rows second. Works for now I just wish there was an easier way to prioritize rules over each other with overlapping ranges.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-05-06 16:07:16 +0200

Seen: 792 times

Last updated: May 10 '14