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.)
Is there a way to change the word list below
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...