Wednesday, June 1, 2011

yogi_Use Multiple Keywords In Conditional Formatting

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
vinhere0 said:
How can i use multiple keywords in "conditional formatting".
In my spreadsheet, i have a column which contains 30 rows with ceratin words. I want to change the rows colour based on the letters. If the word contains any of the letter "A" or "E" or "I" or "O" or "U", then i want to change the colour to red.
i don't want to write 5 different rules for this. I want execute this using one rule.
i tried with the folowing option.
Selected "text contains" from drop down box. And in the text area i entered : "A" or "E" or "I" or "O" or "U", and i checked the background colour and set it to red.
In Google Spreadsheet, at least as of now (Jun-01-2011), you can not use formulas for Conditional Formatting. In the following I present a workaround where column B (not the whole row) can be colored Red in entries in column A contain letters a, e, i, o, or u

In Sheet2, I keyed-in the letters of interest in cell B1 ... thus providing a more generalized solution