I have a spreadsheet like this in LibreOffice
A | B | C | D
-------+----------+---------+---------
1 | A | 1 | B
2 | C | 2 | C
3 | D | 4 | D
What I want is that, the background of column A and C will be either green or red if the content is equal or not equal, respectively. On the example above, cell A1, C1, A2, C1 will be in green while A3 and C3 is red because the content is different.
So far I did something like this using Conditional Formatting.
It works for the first row. But when I tried to drag the cell to the cells below, the content of the cells changed to the original cell.
And when I tried to Paste Special and paste only the formatting, the format will try to compare the cell contents against cell A1.