Sure, it's possible. Add this to the end of your code:
if (event.value=="Low") event.target.fillColor = color.green; else if (event.value=="Moderate") event.target.fillColor = ["RGB", 1, 0.5, 0]; // = Orange else if (event.value=="High") event.target.fillColor = color.red; // etc. else event.target.fillColor = color.white;
Thankyou so much.
Sorry, I've had a further change requested by my Manager... how can I write the code to fill the field with a specific colour - RGB 255, 153, 0 for fields that display Critical and RGB 255, 189, 93 for fields that display High.
I've worked out that the code should be:
else if (event.value=="High") event.target.fillColor = NOT SURE WHAT GOES IN HERE
else if (event.value=="Critical") event.target.fillColor = NOT SURE WHAT GOES IN HERE
Any help would be greatly appreciated.
Use the examples given above as a template, just remember that the values should be between 0 and 1.