googlechromelabs.github.io

{
  "type": "object",
  "properties": {
    "range": {
      "type": "string",
      "description": "Cells the rule applies to, like G2:G20 or Sales!B2:E6."
    },
    "condition": {
      "type": "string",
      "enum": [
        "greater_than",
        "less_than",
        "between",
        "equal_to",
        "not_equal_to",
        "text_contains",
        "is_empty",
        "not_empty",
        "formula",
        "color_scale"
      ],
      "description": "When a cell gets the style."
    },
    "value": {
      "type": "string",
      "description": "What to compare with; for between, the lower bound. Numbers compare as numbers."
    },
    "value2": {
      "type": "number",
      "description": "The upper bound for between."
    },
    "formula": {
      "type": "string",
      "description": "For the formula condition: a formula that is TRUE for cells to style, written for the range's top-left cell, like =$C2>100."
    },
    "text_color": {
      "type": "string",
      "description": "Text color of matching cells, a CSS color like #b42318."
    },
    "fill_color": {
      "type": "string",
      "description": "Background of matching cells, a CSS color like #fde3df. With no style at all, matching cells get a light amber fill."
    },
    "bold": {
      "type": "boolean",
      "description": "Bold text in matching cells."
    },
    "italic": {
      "type": "boolean",
      "description": "Italic text in matching cells."
    },
    "strikethrough": {
      "type": "boolean",
      "description": "Struck-through text in matching cells."
    },
    "min_color": {
      "type": "string",
      "description": "For color_scale, the color of the lowest number.",
      "default": "#ffffff"
    },
    "max_color": {
      "type": "string",
      "description": "For color_scale, the color of the highest number.",
      "default": "#8c88f2"
    }
  },
  "required": [
    "range",
    "condition"
  ]
}