here is a link to my spreadsheet. Yes, it is rough and unpolished but it works for me.
The colors use conditional formatting. Enter the formula into the cell and the results will dictate the color. The colors are set
30%
40%
50%
60%
75%
100%
This is a shared spreadsheet. That means if you change something it changes for everyone. You can make correct adjustments, changes and additions as you find them.