Ask Your Question

Ignoring borders when using conditional formatting. [closed]

asked 2014-03-12 17:28:08 +0200

jcarls gravatar image

updated 2015-09-10 23:39:36 +0200

Alex Kemp gravatar image

Is there any way to set conditional formatting styles so that they simply ignore any and all borders (and/or lack of them) associated with a cell? I'm trying to use a two-level conditional format to set nothing more than the background color, and I'm finding that every variation of border encountered appears to require its own style. The way it apparently works is not even close to being a practical solution, since in almost all real-world situations, the borders should typically be independent of the contents of each cell. Surely there is a way to do this more easily?!?

Note: This is a file imported from an Excel xlsx file. If what I'm seeing is not the normal behavior of an ods file built from scratch, that would be good to have confirmed.

Thanks for any input.

Version: Build ID: 1c1366bba2ba2b554cd2ca4d87c06da81c05d24

Windows XP SP3

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-20 07:42:14.187904

1 Answer

Sort by » oldest newest most voted

answered 2014-03-14 01:24:23 +0200

kumiponi gravatar image

Hi, it's totally possible to ignore borders. When you create a style, you normally base if off another style ("Default" by default). It's in the "Linked with" selection box in the Cell Style dialog box (where you edit the style). Below that is a "Contains" text field that shows what changes your style has from the base style. If you haven't set any borders for your style, then a cell having that style can have any custom borders you want. The conditional formatting won't apply borders either if the style it applies doesn't contain any border values.

edit flag offensive delete link more


Is it possible to apply the top border and to leave all other borders as they are?

alexeymuranov gravatar imagealexeymuranov ( 2018-04-11 18:19:19 +0200 )edit

Question Tools

1 follower


Asked: 2014-03-12 17:28:08 +0200

Seen: 720 times

Last updated: Mar 14 '14