I am having problems with creating a google spreadsheet script that will color rows with certain words in it, then copying those rows to another spreadsheet.
For example, I want to color a row that has the word "banana" blue, then have a copy of that row in spreadsheet A.
Then color a row that has the word "apple" green, then have a copy of that row in spreadsheet B.
And so on.
Can someone help me do this?
If you consider your question in two parts, you'll find that there are already examples here that address them. For your solution, you could adapt the code from those answers.
Previous questions about setting the color of a row according to content:
Previous question about copying rows containing specific colors to specific spreadsheets:
Search results:
StackOverflow supports rich searching within its database - if you do any search, the result page will include an Advanced Search Tips link, that shows you the operators available. You can learn much more on Meta, if you're so inclined.
Here are a couple of the searches used to come up with the examples in this answer.
