Skip to content

Home

Jump to bottom
Amine edited this page Sep 6, 2018 · 2 revisions

Description

This plugin change the background color of each line when you insert or update it (manually or after a form submission). The plugin will check a certain column and check its value, then apply a choosen background color to the line according the to column's value. This helps to visually separate between the lines, which is helpful for long todo lists, form submissions, stock inventories...ect.

Examples

1. Manual edit example:

Manual editi example

2. Form submission:

Form submit example

3. Colorizing an already existing document:

Parse all lines example

How to use

Automatically change line colors

Open the settings panel from the plugin's menu A window will appear letting you specify some settings:

Settings window example

  • Formating rules: let you specify which color to apply to the lines containing the specified value. In case none of these values are found in the watching column, the defaultColor will be applied.
  • Watching column: the number of the column that the plugin will check to look for the specified values.
  • Number of columns: the number of columns in each line that will be colorized.
  • Ignore case sensitivity: if checked, the plugin will consider uppercase and lowercase characters as similar.

Note: You can use color names (red, cyan, green...) or hexadecimal codes (#ff02a3..) in the settings panel.

At each modification or line insertion (including incoming form answers), the plugin will automatically check the watchingColumn's value and apply the corresponding color.

Parse all document and change line colors

You can force the plugin to check all the lines and set the color formating by cliking on the Parse all rows button in the plugin's menu. This operation is useful if you installed the plugin in an already filled spreadsheet, but may take few seconds depending of the size of the document.

Parse all lines example

Feedback / Ratings

Help us increasing the visibility of the plugin by rating the plugin in the the Chrome Web Store.

Your feedback is highly important to help us improve the plugin. Do not hesitate to write your feedback comments in the Chrome Web Store and report any bug here.

Contribute

  • The source code is available here.
  • Feel free to contribute to the repository, by translating the documentation, fixing bugs or adding new features to the code.
  • Please report any bug or error in the issues section.
Clone this wiki locally