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.
Google-sheets – Format a Cell with Script
conditional formattinggoogle sheetsgoogle-apps-script
Related Topic
- Google Sheets – Change Cell Color to Hexadecimal Value in Google Spreadsheets
- Google-sheets – How to change the background color of a cell based on the cell contents using a color lookup sheet
- Google-sheets – Google sheets conditional formatting relative to another cell in the same column
- Google Sheets – Conditional Formatting for Cell Values
- Google Sheets – Use Checkbox to Change Background Color of Cells
- Google-sheets – Google sheets script copying formatting *but not* merged cell status
- Google Sheets – How to Conditionally Format Italics Without Changing Other Parameters
Best Answer
If I understand you correctly, this can be achieved with conditional formatting in New Google Sheets:
The above with Format > Conditional formatting..., Custom formula is
Background checked and yellow chosen, with Range: A1:F6.