No it's not really based on a numerical value at all. We get reports from a credit team that rates a supplier based on key financial areas. For example liquidity could be rated as Good ,so I want the words on the sheet of "Good" and then the cell colored as green. Solvency may be rated as Poor and then that would be shaded as red.
Does that help?
Thank you so much for the response!