a code like this will give an output shown to the right. All you have to do is define a new rule, and then go to “number” tab and set the format code you want.įor eg. Instead of executing step 1 and 2, you can also use the Insert tab to insert a check mark symbol. Use CTRL + c and CTRL + v to copy/paste a check mark or red X. Now you can create a nice to-do list that uses check marks. This means, when the cell value is Y, we can conditional format the cell to show tick mark symbol. To insert a fancy red X, press SHIFT + O to insert a capital O and change the font color to red. Starting with excel 2007, you can use conditional formatting to set cell format codes as well. PS: you need to change the font to “wingdings”. Then we can use custom number formatting to conditionally display the tick mark symbols. Instead of “y” and “n”, user should type “1” and “0”. This approach is more robust, but a compromise. There are 2 simple solutions I can think of (other than the solution proposed by Axim5) 1. I have been trying to do a substitute formula but putting the symbol in an unused portion of the spreadsheet and calling it to the selected cell but I can’t get it to work. I want to have Excel display a wing ding check mark when a user types “y” in a cell. Here is tricky scenario, faced by Basil, our forum member,
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |