font color conditional formatting

[Anonymous]

hi 
i want to show - values in green color nd +ve values in red color
what is the condition i need to use in font color conditional formatting.

[themistoklis]

@Anonymous 

If you want to apply a conditional formatting on the field in a table or matrix you can do it directly though table options instead of creating a new field.

See image below. It is a rule based formatting

[Anonymous · Accepted solution]

Hello @Anonymous,

Create a measure like this and use in conditional formatting.

Measure = IF(MAXX(Sheet1,Sheet1[percent])<0,"#73B761","#de6a73")

[amitchandak]

@Anonymous , You can try rule base

like

-100 to  0 (absolute value, assuming this % column] red

0 to 100 , green

Or a color measure

color  = if([chnage%] <= 0, "Red", "Green")

use that in conditional formatting using field value option