Within Google Docs™, install the Add-on from your Add-ons menu. Once it is installed, go to Add-ons -> Writer's Highlighter -> Start
For help, go to Add-ons menu -> Writer's Highlighter -> Help
In the Add-on, you can hover over the question mark iconswith your mouse. These are located next to each item and the help tooltips will tell you what each item does
You can visit the Add-on's page in the Google Chrome Store for more information.
The spreadsheet settings define where your list of words or phrases is located.
This is the entire link (address/URL) of your spreadsheet, such as: https://docs.google.com/spreadsheets/d/abcdefghijklmnop12345678910/edit#gid=0
To the right is a small gray refresh button if you make changes to the spreadsheet, or just in case it doesn't autoload.
Which tab of the spreadsheet is the word list in? The tabs are at the bottom of the spreadsheet and can be renamed. This list will automatically fill itself out, then you pick the sheet.
Which column of the spreadsheet is the word list in? The columns are at the top of the spreadsheet and start out with A, B, C etc. Column A is the first column. This list will automatically fill itself out, then you pick the column letter.
Check this box to ignore the first row in your spreadsheet. This is useful if you use the first row to name your columns. For example, for a list of Cliches, column A might read "Cliches" in the first cell, then continues with a list of cliches below.
The highlight settings define how your highlight will look.
Checking these boxes will apply these standard formats to your highlight. Keep an eye on the preview text below the color pickers for an example of what it will look like.
Checking the box will apply a colored background to your text. You can enter a hexidecimal color code manually, or use the color picker below to choose a color.
Checking the box will change the color of your text itself. You can enter a hexidecimal color code manually, or use the color picker below to choose a color.
This preview text shows you how each option of the highlight settings above will affect your text. Neat!
The other options define how the add-on will search for words and phrases.
Check this box to highlight any match, regardless of UPPER- or lower-case letters. If the box is not checked, it will only find exact matches.
If the box is checked, searching for "Baseball" will highlight Baseball and baseball and baseBALL.
If the box is not checked, it will only highlight Baseball as it perfectly matches the upper/lower case format.
Check this box to match entire words only and not search within words.
If the box is checked, searching for Base will only highlight Base and not the first four letters of Baseball.
If the box is not checked, it will highlight both Base and the first four letters of Baseball.
I recommend turning this off if you are using the Regular Expressions option, due to the limitation above.
Check this box if you want to use a symbol in your spreadsheet list as a placeholder for letters or words. Select the symbol you use for a wildcard (*, $, #, @, and ~ are supported).
If the box is checked, searching for Feather in * cap will highlight Feather in his cap and Feather in her cap and Feather in your cap and anything else matching that pattern.
If the box is not checked, searching for Feather in * cap will search for literally that phrase, with the star in it.
One wildcard symbol = one word, so searching for Feather * * cap will highlight Feather in his cap and Feather from her cap and Feather under your cap and so on.
Wildcards at the end of words search for the same length or longer words
-- Searching for Feather* will highlight Feather and Feathered and Feathering and so on.
-- Searching for *eather will highlight Feather and Heather and Rebreather and so on.
-- Searching for *eather* will highlight all of the above six examples, and so on.
Wildcards in the middle of words replace one or more letters
-- Searching for F*ther will highlight Feather and Father and Further and so on.
This setting is automatically disabled if "Use regular expressions" is checked, as they are incompatible.
For advanced users, this lets you use Regular Expressions (RegEx) in your search terms.
I recommend turning off "Whole words only" if you are using this, due to the limitations of the Whole words only search pattern.
This setting is automatically disabled if "Use wildcard" is checked, as they are incompatible.
Check this box if you want the highlighter to continue running indefinitely, until you uncheck the box. This allows for real-time text highlighting as you type!
IMPORTANT: continuous highlighting will clear all other highlight formatting (bold, italic, underline, strike, and text colors) from the document, except for the current highlight settings. This is unavoidable in order to have accurate real-time text highlighting.
IMPORTANT: with long word lists and/or long documents, the highlighter may run slowly, or even slow down your browser. Use it responsibly!
The "Highlight!" button will search this document and highlight any words or phrases that match the list in your spreadsheet.
The "Clear all" button will remove all highlight formatting (bold, italic, underline, strike, and text colors) from the document. It will ask for confirmation, so don't worry about hitting it by accident.
The "Highlight selection" button will highlight only the text you have selected with the mouse. That's it!
The "Clear selection" button will remove all highlight formatting (bold, italic, underline, strike, and text colors) from only the text you have selected with the mouse. That's it!
The "View stats" button will pop up a window where you can view statistics about your document, including: word count, paragraph count, syllable count, character count, various readability statistics, a full list of words and their frequency, and a full list of sentences and their frequency.
Note the "Select table" buttons, which select the data so you can copy it into a Google Spreadsheet™ or into a Microsoft Excel™ spreadsheet. To copy the data, click the "Select table" button, then press "Ctrl+C" ("Command+C" on a mac). Then go to your spreadsheet and use "Ctrl+V" ("Command+V" on a mac) to paste the data into your spreadsheet.
Here are previews of the stats pages:
This button will highlight all the sentences in your document by length, similar to the stats view above. Clicking the button again will remove the sentence highlighting, stripping all background color from the sentences. If you don't want to have highlights in your document, use the "View stats" button instead.
The sentence highlight is based on the average sentence in the modern English language being about 20-25 words. Sentences between 20-25 words are highlighted green. Shorter than that, they trend toward purple, and longer than that, they trend toward red. The table of colors is:
Shorter than: 2 words = Color: #CCCCFF
Shorter than: 4 words = Color: #CCD6FF
Shorter than: 6 words = Color: #CCE0FF
Shorter than: 8 words = Color: #CCEAFF
Shorter than: 10 words = Color: #CCF4FF
Shorter than: 12 words = Color: #CCFFFF
Shorter than: 14 words = Color: #CCFFF4
Shorter than: 16 words = Color: #CCFFEA
Shorter than: 18 words = Color: #CCFFE0
Shorter than: 20 words = Color: #CCFFD6
Shorter than: 25 words = Color: #CCFFCC
Shorter than: 30 words = Color: #D6FFCC
Shorter than: 35 words = Color: #E0FFCC
Shorter than: 40 words = Color: #EAFFCC
Shorter than: 50 words = Color: #F4FFBB
Shorter than: 60 words = Color: #FFFFBB
Shorter than: 70 words = Color: #FFF0BB
Shorter than: 80 words = Color: #FFEACC
Shorter than: 90 words = Color: #FFE0CC
Shorter than: 100 words = Color: #FFD6CC
Longer than: 100 words = Color: #FFCCCC
Here is an example of the "Highlight sentences" button in action.
This button will save all of the above settings for the next time you open this Add-on. It will save the highlighter settings for EACH unique combination of (spreadsheet id)+(sheet name)+(column letter). This way you can switch between columns or sheets and it will remember your settings when you switch back -- as long as you save them with this button anyway. (I did not program it to automatically save settings because I wanted to give people the option to save them, or not. Hence this button.)
Below the buttons, there is a message area which will give you the result of your commands and display any errors. While a command is running, it will display an animated "waiting" icon (three dots). This data is not saved anywhere, so if you need to save the number of matches, make sure to copy and paste it somewhere.
Copyright wishinkwell.com © 2018