Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

prioritize overlapping conditional format?

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.

prioritize overlapping conditional format?

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.