Wednesday, March 26, 2014

yogi_Apply Conditional Formatting For Cells That House Letter A (red) , That House Letter B (green) But Not That House AB

                                         Google Spreadsheet   Post  #1575
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Mar-25-2014
post by Pyth (!category-topic/docs/spreadsheets/vRaKaw0dvMA)
Multiple conditional formatting rules applied to same cell?
Let's say I have a column where some cells are going to say "A", some "B", and some "AB". I want all the cells containing "A" to have red text, and all the cells containing "B" to have a green background. So I apply two formatting rules to the column: text contains "A" -> red text (no change to background), and text contains "B" -> green background (no change to text).

Result (in old Sheets, in new Sheets, in Firefox, in Chrome, here or there, anywhere, in a house, with a mouse, in a box, with a fox): Cells that say "A" have red text. Cells that say "B" have a green background. Cells that say "AB" have... red text, but no green background.

I do not like it, Sam I Am.

I could solve this simple toy problem by changing the rules, but in the more general case where I want cell backgrounds to be controlled by one set of rules and cell text colours by another set in ways that might have complicated interactions, there doesn't seem to be a way to easily accomplish it using conditional formatting. And yet, it seems like the sort of thing that should be obviously and trivially possible.