Conditional formatting

Hello Tobias,

First of all I would like to thank you for all previous answers you have given it really helps a lot!
Now Im starting my second project… creating powerrankings on our website using tablepress.
The idea is to let it have a conditional format based on the value in the column. The higher the value the brighter the color green is… from 0-100 and the lower the brighter red it becomes 0- -100 for example.
Do you have any idea how I achieve this automatically? So for example that it instantly becomes bright green when I put in the value 99 and red when I enter -99?

Thanks a lot again!
Roland