Setting background color of cell

Something like this might work for you using a hsl green-to-red colour banding?
The table uses a random number from 1 to 100 to represent a percent so I divide it by 100 which you may not need to - and I used 120 as the initial angle which is 'green'

1 Like