I’m trying to apply conditional formatting to some cells (using Calc) where if the cell contains the word “Complete” it will apply a style I created based on the default called “green border” which simply draws a thicker green border around the cell. If I select a cell and apply the style to it directly it works, so I’m pretty sure I set up the style correctly, but the conditional formatting isn’t applying the style. My condition is "If Cell value is|Contains|“Complete”|Apply Style|Green Border.
What could be the problem?
Other conditional formatting which changes the font color if the condition matches works on other cells in this sheet.
Just wanted to ask if the text “Complete” is actually enclosed in quotes in the dialog (it should).
yes it is!