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...
You cannot make a formula return two different fonts.
You could use the characters ✓✗ - they are available in Century Gothic.
Ok as far as the Check Mark and X goes for Century Gothic, I found that I had to the Insert tab, go into Symbols, select Segoe UI Symbol under the Font drop list and then select Dingbats under the Subset drop list. There I could find the characters and they did not have conflict with the worksheet's Century Gothic font.
You can copy the characters from my previous reply and paste them into a cell.