Forum Discussion
Is there a formula that tells a cell to use a font type based off the content in another cell?
Hello, I have a To Do list in excel, but I do not wish to use the checkbox option as it is a nightmare to manage when trying to remove a selected few. Instead I have chosen to type "y" for yes, "n" f...
Asparagus
Sorry for resurrecting this thread, but I was just doing something similar...
For the ✓ character you can use "=UNICHAR(10003)"
and for the ✗ character you can use "=UNICHAR(10007)"
(Or use those formulae as the result of your "If(" conditional or whatever)
You'd need to have the result cell in a font which has those characters, but I think you'll be surprised how many do.
There are some others just near there too:
| Dec | Hex | UniChar |
| 10003 | 2713 | ✓ |
| 10004 | 2714 | ✔ |
| 10005 | 2715 | ✕ |
| 10006 | 2716 | ✖ |
| 10007 | 2717 | ✗ |
| 10008 | 2718 | ✘ |