Is there a formula that tells a cell to use a font type based off the content in another cell?

Brass Contributor

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" for no and "s" for started. In this example, I have typed them in Column K. I then created a Table and used the Filter formula to make the "y" appear as "P",  the "n" as "O" and the "s" as "Started" in Column L. 


I would like to further add to the formula to chose the Wingding2 font if "y" or "n" is typed in Column K, that way it appears as seen in Column N in the example below ("y" becomes a tick and "n" becomes an x, but "s" has no font change, it remains as my default, Century Gothic). 

PS, it would be a bonus to know that if I wish, I can add another font option like Wingdings2 and Webdings in the same formula. I would settle for the one if anything.


Is this possible?





5 Replies


You cannot make a formula return two different fonts.

You could use the characters ✓✗ - they are available in Century Gothic.

I just did a search for the characters in Century Gothic but did not find the check mark or the x. Where/how do I use them as Century Gothic please?

As far as the formula goes, can it return one font? I am fine with one font if possible.

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.

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: