Background Colour for Table

[ronman10]

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 

[Prashant_Naik · Accepted solution]

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

[ronman10]

Thanks Prashanth!

Best Regards,

Rony