I need to create a script for google sheets

Budget 129$ per month

Posted: 5 years ago

Opened

Description: I am using google sheets. My students are writing a story and I want to put their story in a cell. then I want to color the text based on one of four criteria. I have word lists based on frequency of use in English. so I have the top 400 the top 800 the top 1200 and the top 1600 most used English words. I would like a script that would look through the students story and match the word to a word list and color it accordingly, so that words 1-400 were red, 401-800 were green, 801-1200 were blue and 1201-1600 were purple all the remaining words could remain black. I have the word lists in columns.
Skills:
English,software development

Source: peopleperhour.com