Conditional formatting - give number fields a colour based on their value

Hi All,

On Project level we provide scores which needs to be entered by Quality Assurance. This can be from 0 to 5 with one decimal. e.g. 3.5.

Is there an option to have conditional formatting in place that the field show a color with a specific score?
0>3 = Red
3>4 = Orange
4> = Green

Thanks in advance.

1 Like

I’m afraid there isn’t at the moment.

Do you need to calculate or roll-up the field values?

If not, you could use a single select field as opposed to a number field as a workaround.

1 Like

@Jan-Rienk, thanks for the answer. This is an alternative I already thought about this, but this gives me 50 options. Not a realistic option for me.

I assumed as much. I adjusted the title and transformed moved this thread into product feedback so so you and others can vote for this feature.

(And voted for it myself since I like the idea. :slight_smile: )

1 Like

Hi @Niels_Oomen , for what it’s worth, the current limit is 500 options for single-select and multi-select fields - it used to be 50 a couple of years ago.

Refer to 1.2 here.