I am currently trying to create a formula that returns a threat level with text like "serious" "moderate" "none" with each box filled green yellow or red based on threat level. It is for an inventory order list. I have my par level in Column C, My current inventory in D, and the needed amount in E. Do you know some sort of way I could do this?
