Ask Your Question

Conditional format apply colored border not working [closed]

asked 2017-01-29 17:31:06 +0100

icb gravatar image

updated 2017-01-29 17:31:58 +0100

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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-22 09:25:46.320371

1 Answer

Sort by » oldest newest most voted

answered 2017-01-29 21:40:48 +0100

Just wanted to ask if the text "Complete" is actually enclosed in quotes in the dialog (it should).

edit flag offensive delete link more


yes it is!

icb gravatar imageicb ( 2017-01-30 09:03:42 +0100 )edit

Question Tools

1 follower


Asked: 2017-01-29 17:31:06 +0100

Seen: 76 times

Last updated: Jan 29 '17