Is there a way to change the font of a cell with a formula? What I need to do is check 20 cells in a column, and if all 20 cells are filled in I want a check mark which I can get from Font:Wingdings which is Char(252). Now if there are not text in all 20 cells, it is just going to count, and give me a number, but I have to switch fonts again. Any ideas on this? I can do the If formulas and stuff, just don't know what to put in to change Font from Arial to Wingdings or visa versa.