Nov 08 2022 07:32 PM
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?
Nov 09 2022 12:21 AM
You cannot make a formula return two different fonts.
You could use the characters ✓✗ - they are available in Century Gothic.
Nov 09 2022 03:55 AM
Nov 09 2022 04:33 AM
Nov 09 2022 05:47 AM
You can copy the characters from my previous reply and paste them into a cell.