Here's a sample file. I've tried using conditional formatting but I can't get it to treat blanks, div/0, etc correctly. I'm trying to only pick up the values for color when there's an actual value there in the % column. My original thought was to just step through the column cell by cell and evaluate each one then change fill color as the criteria dictate.

thanks