Red and green color percentage table

[#1]

Hi

How can I create red color for negative % and green for positive % in following table? Can't seem to manage with proper formula under background formula expression. Thanks

The underlying formulas for V (Volume) and VpM (Volume previous month) are as follows:

V: Sum([#Quantity])

VpM: sum({<Month=, Date={">=$(=monthstart(max(Date),-1))<=$(=monthend(max(Date),-1))"}>} [#Quantity])

%CH: Sum([#Quantity]) / sum({<Month=, Date={">=$(=monthstart(max(Date),-1))<=$(=monthend(max(Date),-1))"}>} [#Quantity])-1

[shraddha_g]

try in background color:

if(

(Sum([#Quantity]) / sum({<Month=, Date={">=$(=monthstart(max(Date),-1))<=$(=monthend(max(Date),-1))"}>} [#Quantity])-1) <0,red(),green()

)