Changing color based on score

Hi @22Derebe,

Try using this formula:

if((${Q1} <=7), ‘<span style=”color:red”>Low</span>’, if((${Q1} >= 8 and ${Q1} <= 11), ‘<span style=”color:yellow”>Medium</span>’,if((${Q1} >= 12),’<span style=”color:green”>High</span>’,'')))

Reference xlsform:
Changing colour with the value.xlsx (11.3 KB)

Have a great day!

1 Like