Gauge Panel using Google Sheet

This is a panel of sixteen gauges.  I am working on getting the labels
for each gauge to turn the color of the range the needle is pointing
within the gauge.