Apache OpenOffice Community Forum

Here is what the Libre Office Help says:

https://help.libreoffice.org/Calc/Apply ... Formatting

###QUOTE###
Step 5: Copy Cell Style
To apply the conditional formatting to other cells later:

Click one of the cells that has been assigned conditional formatting.
Copy the cell to the clipboard.
Select the cells that are to receive this same formatting.
Choose Edit - Paste Special. The Paste Special dialog appears.
In the Selection area, check only the Formats box. All other boxes must be unchecked. Click OK.
###UNQUOTE###

unfortunately, in reality, the copied cell does not behave as the original cell. In my case: IF $A$1 unequal $B$1 make $B$1 turn red. If I copy $B$2 this cell remains red regardless of the input in $A$2.

solution?

How exactly is the conditional formatting defined? If it refers to $A$1, then when copied it will still refer to A1. If the conditional format refers to A1, then it will shift to A2 when copied. At least, that is how it works in OpenOffice.

ahaaaa....thanks a lot, that's the solution. Strings taken out and it works!

FYI: The $ in the cell addresses is called the absolution character. It is the difference between absolute and relative for the column/row.