Conditional Formatting help!

[crave4excel]

Hi,
is it possible to create conditional formatting of icon set as an indicator of task status, i.e. if an action is "in progress", i want to show a yellow circle icon next to "in progress", if an action is "completed", i want to show a green circle icon next to it.

The icon set currently in Excel only seems to follow either number or percentage values, instead of text.


Thanks!

 

[cooper645]

have a look at this thread, which covers a good work around.

https://www.mrexcel.com/forum/excel-questions/589125-using-icon-sets-excel-2007-text-values.html

This is my work around solution,

Then just check the show icon only box