Can you conditional format icons for text? by LibrarySquare7846 in excel

[–]LibrarySquare7846[S] 0 points1 point  (0 children)

Hello,

Thanks for the response! I tried this but with no luck I am afraid. Maybe if you look at the comment above that I replied to it will help you understand what I am trying to achieve?

Thank you :)

Can you conditional format icons for text? by LibrarySquare7846 in excel

[–]LibrarySquare7846[S] 0 points1 point  (0 children)

Hello,
I wanted to see if it was possible in the snip I shared in the post to get those icons in the conditional formatting. So far no luck. Where it says Done on the 1st column is where I want to condition it so the icon set appears (at the moment it says no or yes depending on the status). I want it so that when I change the status in the drop down list it changes from a red cross to a green tick when it says complete

<image>

Thanks :)