5

It was easy to do in Excel, but I am having trouble following some of the scripts written on here. Basically we have 3 colors we use, Green, Yellow and Red. 1 = Green, 2 = Yellow and 3 = Red. What I would like to happen is the shading change depending on the number. So if the field has a value of 1, it will be green, if it has 1.5 it will be a greenish, yellow tint. Is there a way for me to do this, or can anyone pass over some simple custom expressions that I could tweak for this?

1

The Conditional Formatting rules can accomplish that.

Result:

Colours

Rules:

Rules

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.