Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/04/Excel-icon-sets-based-on-text.xlsx

In this video, I demonstrate how to apply conditional formatting icon sets to text values. This is fairly easily achieved with numeric values, but it's not so obvious how to achieve the same thing with text values.

I demonstrate two methods in this video. The first applies if you want to use up to three icons and the second applies if you want to use up to five icons. Both methods use a combination of conditional formatting and custom number formatting.
------------------------