Apps script conditional formatting for value not in array-CodePudding

Home > database > Apps script conditional formatting for value not in array

Apps script conditional formatting for value not in array

Time：07-17

I have a column containing US state abbreviations. I'd like to have an array of all 50 states:

const states = ['DE','AK','TX','CA' .........]

that the value of each cell in the column is compared against. If its not one of the states I'd like to format it red.

I've looked at conditional formatting (