Is it possible to have 2 different format opt...

[Brady_Lovell]

Is it possible to have 2 different format options for the same column?

I have a gSheet displaying live weather and one of the columns is labeled [Forecast]. When I bring it into AppSheet, I format it so that all of the text is green, in color. The forecast column gets populated with words like “Mostly Cloudy”, “Cloudy”, “Rain”, etc…

I want to be able to highlight the text in the color Red, whenever the words “Rain” or “Showers” or “T-storms” shows up in the [Forecast] column. Please see attached. I’ve tried a bunch of different AND, NOT, OR combo’s and can’t seem to figure out. Anyone have any ideas?

Thanks