Ask Your Question

How am I able to change grid color if value is = 1

asked 2020-10-04 12:17:53 +0100

teksi gravatar image

(Using Libreoffice Calc)

I am trying to learn how can I do a thing that colors up the grid that displays number "1" and then if there's something else it will not have the color.

edit retag flag offensive close merge delete


You can't change the grid color, because the grid color is not a property of a cell but of the sheet(s). You probably mean: How to set a border color of cells having value 1.

Opaque gravatar imageOpaque ( 2020-10-04 12:50:39 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-10-04 13:01:34 +0100

Opaque gravatar image

updated 2020-10-04 13:03:22 +0100


Step 1 - Create your desired Cell Styles

  • Open your document
  • Styles -> Manage Styles (or F11
  • Click icon leftmost (beneath Styles), which is Cell Styles
  • Right click on Default / Default Cells Style and New...
  • Provide a name (e.g. ColoredBorders)
  • Make your setting in tabs Borders
  • Click OK

Step 2 - Define the Condtional Formatting

  • Select the cells which should contain the Condtional Formatting (e.g. A1:J40 i.e. row 1)
  • Format -> Conditional -> Condition...
  • Condtion 1 - Cell value is - equal to - 1 - Apply Style: ColoredBorders
  • Finally click button OK

image description

See also the following sample file: C:\fakepath\ConditionalColoredBorders.ods

Hope that helps

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-10-04 12:17:53 +0100

Seen: 22 times

Last updated: Oct 04