Format Rule for text and number

[Phong_Lam1]

Hi all, I try to format the text from column result with color, but It just not work, anyone know why

Thanks !

[1minManager]

So possibly where your getting confused is that the format rule applies to the entire data in the column. It won’t allow you to have a multicoloured list. Which is what I presmume you’re trying to do. If you add that rule then in the App set [Result] to “1 - Very Bad” then that column should change to red.

[Phong_Lam1]

Sorry for more clarity, I added rules for 6 options of result, but the column not change to red or other colors on the and and the dropdown list also

In other section of the app I can do it

[1minManager]

Hmm. Try changing the option to just “bad” to see if its some text issue.

Also check for other formating rules that would match this text. They may be superseeding this rule

[Phong_Lam1]

I changed It to “Bad” and the app could not sync anymore, What can I do to reverse back to previous stage ? It’s always have number 1 in red on the sync button, when I click sync It’s show error

[1minManager]

Either simply change it back to what it was or go to Manage → Versions and roll it back to an earlier version

[Phong_Lam1]

It’s just so weird, I was synced dozen of times. It’s still not work. But when I closed every things and restart the Chrome. The format rule work now, but number 2 not work…Thank you @1minManager for taking time to help !

[1minManager]

Ahh ok. Looks like a browser caching issue then. Thought it was a bit weird. Be sure to clear your temporary internet files if anything similar happens