Feb 17 2023 11:45 AM - edited Feb 17 2023 11:47 AM
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.
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".
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?
Feb 17 2023 12:02 PM
SolutionFeb 17 2023 03:12 PM
@Riny_van_Eekelen Oh you are awesome. Thank you