Color expression in if statement along with condition in kpi
Attached is a sample excel sheet,
i want a value in red and green color in the KPI,
I'm using the below expression to achieve the same, but not finding the result.
if(E<0,-(E) and red(), 0 and green())
What i'm trying is , if the value of E is less than zero or negative, i am making E positive and i want that to be in red() color and if the value of E is greater than or equal to zero and positive i'm making E to be Zero and i want that to be in green(). but the above expression yields - sometimes.