Harvey Balls / Alternative to represent 5 Categories


Hello Everyone,

I'm looking for a solution to either get a colored Harvey Ball or a Symbol / Text to reflect 5 different categories: Grey - Green - Yellow - Red - Dark Red

Is there a way to avoid the conditional formatting solution I have in the first column below to get a Harvey Ball look & feel? (I would also be happy to have a colored box or any other symbol with good visibility - I tried ASCII Codes but as the Fonts are limited I only got a "empty box" symbol)

Thanks for any thoughts! Iris

Best Answer