color in table based on variable

[#1]

how can you color   have multiple colors when using the Background color expression?

Below is what I am trying with no luck.

if(ActPkgCost/PurchPackSz<0.25, green(),

              if(ActPkgCost/PurchPackSz>0.25, <0.50 Yellow(),

              if(ActPkgCost/PurchPackSz>0.50, Red())))

[sunny_talwar · Accepted solution]

Try this

If(ActPkgCost/PurchPackSz < 0.25, Green(),

     If(ActPkgCost/PurchPackSz < 0.50, Yellow(),

          If(ActPkgCost/PurchPackSz > 0.50, Red())))

[mjtaft2017]

Hi Sunny -

Is yours (above) missing a comma just before Yellow()  - I included the comma below 

If(ActPkgCost/PurchPackSz < 0.25, Green(),

     If(ActPkgCost/PurchPackSz < 0.50, Yellow(),

          If(ActPkgCost/PurchPackSz > 0.50, Red())))

color in table based on variable

[sunny_talwar]

I did

[Anonymous]

OK, if we're speaking of improvements...

If(ActPkgCost/PurchPackSz < 0.25, Green(),

     If(ActPkgCost/PurchPackSz < 0.50, Yellow(),

          Red()))

[mjtaft2017]

try Sunny's or try this with your original

if(ActPkgCost/PurchPackSz<0.25, green(),

              if(ActPkgCost/PurchPackSz >= 0.25 and ActPkgCost/PurchPackSz < 0.50, Yellow(),

              if(ActPkgCost/PurchPackSz >= 0.50, Red())))