Dynamic Colouring

[Anonymous User]

Hello 

Good night, I've been trying to create a dynamic color, in which I put this code:
#ff7373 is red
#5ac18e is green
#E7E7E7 is gray

if(int(${perc1}>100), "#ff7373",
if(int(${perc1}<100), '#5ac18e','#E7E7E7'))

if it goes beyond 100% it's a color
if it doesn't pass it will be another

can you help me to understand why it never goes out of the gray color?

thanks

[IsmaelChivite]

You can attach your XLSFile to your question. It will help you get answers. Upload a simplified version of your survey to keep things easy.

[Anonymous User]

Good Morning I send xlsform in order to facilitate the understanding of the code thanks

[DeonLengton · Accepted solution]

Hi

Your brackets were incorrectly placed.

if(int(${perc1})>100, '#ff7373',
if(int(${perc1})<100, '#5ac18e','#E7E7E7'))

This fixes it.

[Anonymous User]

its work, thanks