How do I set a color to a specific value in a data table based on limits from other columns?
Dec 13, 2019 3:38 PM(1300 views)
I am trying to color cells in jsl based on if they are over, under, or between limits. In this case Amanda is too short for the roller coaster so I want the box to be blue. Jeff is too tall, so I want the box to be red. Luke meets the requirement for the water slide, so that box can be green.
I went into column properties and tried "value colors" but that will not work for me because you must already know what colors you want to assign to what values. Certain values will need to take on different colors based on the ride limit. Sometimes a height of 66 will be green, but for a different ride it maybe too tall, and therefore red. I also tried "color gradient" this will not work because it uses many shades or blue, red, and green. I only want 3 colors.