Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I have created a simple table which contains only percentages. Dimension is YearMonth. I want the cell background color to be as per below:
- <0 red
- >=18% orange
- > 18% green
Please help.
Best Regards,
Rony
Hi Rony,
This might help you
Percentage expression = A/B
if(Percentage expression<0.00,red(),
if(Percentage expression>0.00 and Percentage expression<=0.18,
cyan(),
green()
)
)
Regards,
Prashant
Hi Rony,
This might help you
Percentage expression = A/B
if(Percentage expression<0.00,red(),
if(Percentage expression>0.00 and Percentage expression<=0.18,
cyan(),
green()
)
)
Regards,
Prashant
Thanks Prashanth!
Best Regards,
Rony