Conditional formatting for percentage change

[Katlego_Hlangwane]

Hi guys,

Which formula can I use to create a condition that will change text color when there is a percentage change in the data?

(E.g. If percentage is >1 then text color turns green, else color turns red)

Look forward to hearing from anyone who can assist.

Please see attached for reference:

[Mihaly_Toth]

Follow this thread. It helped me as well.

Programmatically change the background color of a component

Hi, if you have an internal property that matches the category, you can Create a new color palette: [image] [image] Bind the background color to a formula that uses an internal property of the card component: [image] For example the formula {news: "blue", announcements: "red"}[internalProps.title] will give you a blue card if the title is “news” and a red one if the title is “announcements”. If the categories you’re using aren’t bound to any internal property, you can create a new one…