Color conditional table

[Wubek]

Hello,

i have a question about using color conditional based on two fields from table. Basically i want to color 1 cell if sales>than budget, but this:

```

if(sum(sales)/sum(budget), LightGreen(), LightRed())

```

is not working. Could someone help me?

[tresesco]

But you are not using '>' symbol but '/' ?

[Rams- · Accepted solution]

Hi, 

You can use this expression in background color expression:

if((Sum(Sales)>Sum(Budget)),LightGreen(), LightRed())

Output:

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

[Wubek]

Thanks @Rams-