Excel 2016. Automatically creating ranges based on cell contents then conditionally formatting the range
This is pretty easy in Excel 2016 for Mac.

Set up your grid and select the range.



Define your three color conditional coloring to the range.



Enjoy