Newbie Questions

Re: Conditional Formatting Restriction

Hilary Stoupa — Fri, 21 Sep 2012 17:27:17 GMT

That is because you are not putting them together into a single condition. Copy the expression from the first row. In the last row, after the condition, type the word "and" and then past in the condiition from the first row. Now row 5 has 2 conditions, and you can use row one for another condition. Does that make sense?

Re: Conditional Formatting Restriction

Moe1950 — Fri, 21 Sep 2012 16:55:18 GMT

But I still only get 5 conditions....see word doc in attached zip

Re: Conditional Formatting Restriction

Hilary Stoupa — Fri, 21 Sep 2012 16:41:10 GMT

There sure is - you can change the first drop down in the conditional formatting UI to "The expression ..." and then put your own expression in, using "and" and "or":

my:field1 = "Test" and my:field2 = "NotTest" and my:field3 = "snuffaluffagus"

Conditional Formatting Restriction

Moe1950 — Fri, 21 Sep 2012 14:34:36 GMT

I need to add more than 5 conditions to a conditional formatting setup. Is there a way around the 5 condition limitation?