curtis.walker@sgmc.org re:Fill Color
Maybe I'm simplifying this too much but, why not use conditional formatting to do the work for you. Using the Highlight Cells Rules conditional formatting, you can set the colors to highlight for 'good' and 'bad' based on what defines each.