Is it possible to set a conditional formatting with 3 results?
If the result of 80 or more, the cell shows “Go”
If the result is lower than 80, but higer than 50, the cell shows “Caution”
If the result is lower than 50, the cell shows “Run”.
Thanks
Page 1 / 1
Assuming you have a field called “Result”, create a formula field with this as the formula:
Take a few minutes to read this, it’ll help sooooo much:
Thanks for the answer. But I’ve made that, and it didn’t worked. I’ve read the formula field reference, and the conditional formating reference, and it didn’t worked. =(
Thanks for the answer. But I’ve made that, and it didn’t worked. I’ve read the formula field reference, and the conditional formating reference, and it didn’t worked. =(
My mistake! I placed a space between the IF and the (
I’ve edited my previous answer and tested it:
Worked. Thanks =) Now I have the ultimate Airtable to use in my negotiations (I’ll know exacly, how much discount can I give, and how much everything will cost to me and to my clients). =)