How do I turn the text red in a cell if the string in the cell is different from the string in the cell to its left? I have looked at conditional articles on the wiki (https://help.libreoffice.org/) however, the articles I found did not specify what needs to be in the cells.
I have looked in Format > Conditional Formatting and could not find a way to enter the expression.
Please include step by step screen shots. The input boxes are not user friendly.