Using Smiley icon in Excel

Using Smiley icon in Excel is one of the most asked questions. 

First of all, is is a character like J,K,L. But is Windings font. 

You should build your IF sentences accordingly. Then create charater with CHAR function. 

Such as; IF (a1>b2;CHAR(74);.......).  Then format the cells where smileys are seen with Windings. 

Excelskill.com, is a very unique Excel training video site, provides hundreds of video that shows advanced Excel topics. Videos presented by very experienced and talent Microsoft Certified Trainer - Faruk Cubukcu.
Most videos are unique solutions that will be easily adapted to your job. You can watch these videos to see how Excel makes it easy to use Excel functions (such as LARGE, MID, VLOOKUP, LOOKUP and SUMIF functions). Also data analysis skills, sort and filter features and advanced use of Pivot tables and charts.
There are many videos to learn advanced use of IF function. Including nested IF functions, IF with AND and OR, also COUNTIFS and SUMIFS, and AVERAGEIFS, IFERROR and IS…
You can learn conditional formatting and data validation techniques in a custom way. Also how to use the functions in various scenarios, in large spreadsheet, and on other worksheets and workbooks.
Excelskill.com videos categorized by, general, data analysis, finance, statistics, macros and VBA. All videos recorded in Excel 2013, but most of them relevant to the 2010 and 2007 versions as well. After you have watched the videos, you can download the data file and make hands-on exercises on them.