Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Ignoring borders when using conditional formatting.

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: 4.1.5.3 Build ID: 1c1366bba2ba2b554cd2ca4d87c06da81c05d24

Windows XP SP3

Ignoring borders when using conditional formatting.

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: 4.1.5.3 Build ID: 1c1366bba2ba2b554cd2ca4d87c06da81c05d24

Windows XP SP3