Conditional Formatting failed

[emilyrabbit]

HI ,

I want to set up the conditional formatting. but it failed. the color failed to change.

the result:

Thanks in advance.

 

  

[PrashantSangle]

try simple

if(yourexpression>0,Green(),Red())

[emilyrabbit]

Hi ,

Thanks. But I need to define a specific color. 💔

[PrashantSangle · Accepted solution]

which color. you can use RGB()

if(yourexpression>0,RGB(255,10,10),RGB(10,255,20))

If you need symbol for up arrow and down arrow then add that in your expression only

[Kushal_Chawda]

@emilyrabbit  do you want to apply colour or symbol to the numbers?

[emilyrabbit]

HI ,sorry I have a further question:

I set the below expression in the KPI chart . and you can see , the number changed the color. Could I know why?

And the weird thing ,I put the same expression in another chart , it didn't change the color. I am totally lost.

 

[Kushal_Chawda]

@emilyrabbit  Sometimes it happens that we don't understand what is happening due to may be bug. Instead trying to get your head around, create new object and see if that works

[emilyrabbit]

hi，I tried. It still the same. sad..