I haven’t found the way to change cell background via formula, but as for the others —
- You can programmatically set text color with a hidden
_Color(text, color)function; - You can draw data bars of arbitrary color and length with
Rectangle(...), e.g. see how I did something similar here.
In fact, let me quickly put something together.