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!