How to change the text colour to red when value < 0 % ?

[Paulyeo11]

Hi All

[amitchandak · Accepted solution]

@Paulyeo11 , Under format -> Data Label, You have fx icon, Click on that and create conditional formatting.

-1 to 0 red (If column is % else -100 to 0)

>0 to 1 (green)

[Anonymous]

HI @Paulyeo11 ,

Below link can help you in doing this.

Appreciate your kudos !! Please mark my post as solution if this is what you are looking for.