Conditional Coloring Between 2 Values

I want to highlight numbers between 1 and 100 as red, yellow, or green

  • Numbers from 75 to 100 would be highlighted as green
  • Numbers from 50 to 75 would be highlighted as yellow
  • Anything less than 50 would be highlighted as red

Currently the function to select a range between two different numbers is not available. This would greatly help the visual effects when reporting out on data.


Ranges would make sense. So would being able to reorder the conditions.

You can do what you want now using just a bit of logic. The later conditions take precedence. So, if you define your conditions in order:

  1. number < 100 green
  2. number < 75 yellow
  3. number < 50 red


Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Should I convert my Integromat account to Make? - YouTube
Contact me directly here: Contact – The Monday Man

Thank you. That seems to work!



This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.