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

(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.

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.

Hello,

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

See also the following sample file: ConditionalColoredBorders.ods

Hope that helps