I need to write a script to see if a cells value is found in an array, and if it is change the background color of that cell. Can't do this with "Conditional Formatting" as it needs to compare with 25 - 30 values.

  • Hi Frank, I hope you will return to see the answer, given by @pnuts. Seems like you posted a hit-an-run question..... – Jacob Jan Tuinstra Mar 21 '14 at 19:34

If I understand you correctly, this can be achieved with conditional formatting in New Google Sheets:

WA57294 example

The above with Format > Conditional formatting..., Custom formula is


Background checked and yellow chosen, with Range: A1:F6.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.