Ask Your Question

Conditional format apply colored border not working

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

icb gravatar image

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

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 close merge delete

1 Answer

Sort by » oldest newest most voted

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

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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 38 times

Last updated: Jan 29 '17