CODEWITHSUNDEEP
javascriptgoogle-apps-scriptgoogle-sheets
Dong Nguyen
Dong Nguyen

Reputation: 1

Google Spreadsheet script to color rows containing a certain word and automatically move the row to another sheet

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?

Upvotes: 0

Views: 2042

Answers (1)

Mogsdad
Mogsdad

Reputation: 45710

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.

  • [google-apps-script] +color +row +sheet is:question Results
  • [google-apps-script] +color +row +sheet +copy Results

Upvotes: 1

Related Questions