Conditional formatting on graphs

For bar and dot plots, it would be great to have conditional formatting on the colours. This would be set by range of values for each bar. The current colour settings would be the default, and for each plot you could define one or more ranges of values that would set a different colour e.g. 0-50 bar is red, 50.1-70 yellow etc

A more advanced version would allow that to be a dynamic range eg
Less than 80% of average for past 14 days - red
80%-90% yellow
90%+ Green

I’m thinking here of the different coloured bars in HRV4 training but there are other applications for this eg sleep score below a certain value - the dots could be coloured differently