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.

@jgore

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

Q.E.D.


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!

~WRD037.jpg

image001.png

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