SOLVED

Can I use the Conditional-formatting check symbol without having to see the number?

Copper Contributor

I'm looking to make a spreadsheet with check symbols.  I know how to insert the checkbox control and I know how to use the "Wingdings" font symbol to get that.  But what I really want is the big green check mark that I see under the "Conditional Formatting >> Icon Sets" dropdown. 

iconset.png

I set up some sells to use that and yes, it was great:  If I enter the number "1" I get a big green check mark next to it.  If I enter the number "0" I get a big red "X".  

icon.png

The only problem is that I *only* want to see the check or the X.  I don't want to see the number beside it.  Is there any way to conditionally format this so that I can type the number and then have it disappear and only the icon shows up?

2 Replies
best response confirmed by Joe_OLeary (Copper Contributor)
Solution

@Joe_OLeary Edit the rule and choose "Show icon only".

Screenshot 2023-02-17 at 21.01.27.png

(Picture taken on a Mac, but similar on a PC)

1 best response

Accepted Solutions
best response confirmed by Joe_OLeary (Copper Contributor)
Solution

@Joe_OLeary Edit the rule and choose "Show icon only".

Screenshot 2023-02-17 at 21.01.27.png

(Picture taken on a Mac, but similar on a PC)

View solution in original post