How to Use Conditional Formatting Icon Sets with Text | Excel Traffic Lights Based on Text

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
Thank you! 👍👍

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.
------------------------

[hughraftery]

This is genius. I was searching for a way to apply icon sets to text fields, this solution is perfect. Thanks for posting. 😀

[mobilemac]

Thank you so much, I spent hours watching videos and trying to figure this out until I found your video!

[IvanCortinas_ES]

Excellent tutorial Chester. Thank you very much!

[marmanlive]

What if the the values in column D are selected from a list of values (drop-down) instead of being manually entered? Data validation blocks VLOOKUP formula... so text values and their numeric values are stored on another sheet, how to specify column number in the range containing the value to return?

[vascocruz]

other versions of excel have different syntax for for the VLOOKUP, mine was: . (F9) was the cell that i wanted to have the number, equivalent to D4 in the video