Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

CF change text to 3 symbol icon set or symbol


Is there a way to change the word list below

  • Green
  • Yellow
  • Red
  • Gray

into either the CF (conditional formatting icon set)? Or replace the words with colored symbols?I have the below set and I need to change the word into a visual report with colored symbols 




What I would do is to assign each color a number value and then insert a new column next to the text and input an IF statement that outputs the correct number for each color.

Then, copy the IF statement down, apply conditional formatting to the column that now has numbers, select that column, make the text the same color as the background, resize the column to fit the icon set or symbols that you chose.

The IF statement could be something like this:

=IF(A1="Green",1,IF(A1="Yellow",2, etc...

Answer the Question

You must create an account to use the forum. Create an Account or Login