Google Sheets Status Icon Formulas

Traffic light status

Put red, yellow, or green in A1.

=IF(A1="red","🔴",IF(A1="yellow","🟡","🟢"))

🟢

IF

Yes / No checkmarks

Put Yes or No in A1.

=IF(A1="Yes",CHAR(10004)&" Yes","✗ No")

✔ Yes

IF CHAR

Yes / No with Black Star and New Moon blank

Put Yes in A1 for black star. Anything else shows new moon.

=IF(A1="Yes","★",UNICHAR(127761))

★

UNICHAR IF

Yes / No with Black Star and White Large Square blank

Put Yes in A1 for black star. Anything else shows white large square.

=IF(A1="Yes","★",CHAR(11036))

★

CHAR IF

Yes / No with Black Star and White Small Square blank

Put Yes in A1 for black star. Anything else shows white small square.

=IF(A1="Yes","★",CHAR(9643))

★

CHAR IF

Yes / No with Black Star and White Medium Square blank

Put Yes in A1 for black star. Anything else shows white medium square.

=IF(A1="Yes","★",CHAR(9723))

★

CHAR IF

Yes / No with Black Star and Dotted Line Face blank

Put Yes in A1 for black star. Anything else shows dotted line face.

=IF(A1="Yes","★",UNICHAR(129509))

★

UNICHAR IF

Yes / No with Black Star and Prohibited blank

Put Yes in A1 for black star. Anything else shows prohibited.

=IF(A1="Yes","★",UNICHAR(128683))

★

UNICHAR IF

Yes / No with Black Star and Black Large Square blank

Put Yes in A1 for black star. Anything else shows black large square.

=IF(A1="Yes","★",CHAR(11035))

★

CHAR IF

Yes / No with Black Star and Black Square Button blank

Put Yes in A1 for black star. Anything else shows black square button.

=IF(A1="Yes","★",UNICHAR(128274))

★

UNICHAR IF

Yes / No with Black Star and Black Small Square blank

Put Yes in A1 for black star. Anything else shows black small square.

=IF(A1="Yes","★",CHAR(9642))

★

CHAR IF

Yes / No with Black Star and Black Medium Small Square blank

Put Yes in A1 for black star. Anything else shows black medium small square.

=IF(A1="Yes","★",CHAR(9726))

★

CHAR IF

Yes / No with Black Star and White Square Button blank

Put Yes in A1 for black star. Anything else shows white square button.

=IF(A1="Yes","★",UNICHAR(128275))

★

UNICHAR IF

Yes / No with Black Star and White Square with Rounded Corners blank

Put Yes in A1 for black star. Anything else shows white square with rounded corners.

=IF(A1="Yes","★",CHAR(9634))

★

CHAR IF

Yes / No with Black Star and White Circle blank

Put Yes in A1 for black star. Anything else shows white circle.

=IF(A1="Yes","★",CHAR(9898))

★

CHAR IF

Yes / No with White Star and New Moon blank

Put Yes in A1 for white star. Anything else shows new moon.

=IF(A1="Yes",CHAR(9734),UNICHAR(127761))

☆

CHAR UNICHAR IF

Yes / No with White Star and White Large Square blank

Put Yes in A1 for white star. Anything else shows white large square.

=IF(A1="Yes",CHAR(9734),CHAR(11036))

☆

CHAR IF

Yes / No with White Star and White Small Square blank

Put Yes in A1 for white star. Anything else shows white small square.

=IF(A1="Yes",CHAR(9734),CHAR(9643))

☆

CHAR IF

Yes / No with White Star and White Medium Square blank

Put Yes in A1 for white star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(9734),CHAR(9723))

☆

CHAR IF

Yes / No with White Star and Dotted Line Face blank

Put Yes in A1 for white star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(9734),UNICHAR(129509))

☆

CHAR UNICHAR IF

Yes / No with White Star and Prohibited blank

Put Yes in A1 for white star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(9734),UNICHAR(128683))

☆

CHAR UNICHAR IF

Yes / No with White Star and Black Large Square blank

Put Yes in A1 for white star. Anything else shows black large square.

=IF(A1="Yes",CHAR(9734),CHAR(11035))

☆

CHAR IF

Yes / No with White Star and Black Square Button blank

Put Yes in A1 for white star. Anything else shows black square button.

=IF(A1="Yes",CHAR(9734),UNICHAR(128274))

☆

CHAR UNICHAR IF

Yes / No with White Star and Black Small Square blank

Put Yes in A1 for white star. Anything else shows black small square.

=IF(A1="Yes",CHAR(9734),CHAR(9642))

☆

CHAR IF

Yes / No with White Star and Black Medium Small Square blank

Put Yes in A1 for white star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(9734),CHAR(9726))

☆

CHAR IF

Yes / No with White Star and White Square Button blank

Put Yes in A1 for white star. Anything else shows white square button.

=IF(A1="Yes",CHAR(9734),UNICHAR(128275))

☆

CHAR UNICHAR IF

Yes / No with White Star and White Square with Rounded Corners blank

Put Yes in A1 for white star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(9734),CHAR(9634))

☆

CHAR IF

Yes / No with White Star and White Circle blank

Put Yes in A1 for white star. Anything else shows white circle.

=IF(A1="Yes",CHAR(9734),CHAR(9898))

☆

CHAR IF

Yes / No with Outlined White Star and New Moon blank

Put Yes in A1 for outlined white star. Anything else shows new moon.

=IF(A1="Yes",CHAR(9885),UNICHAR(127761))

⚝

CHAR UNICHAR IF

Yes / No with Outlined White Star and White Large Square blank

Put Yes in A1 for outlined white star. Anything else shows white large square.

=IF(A1="Yes",CHAR(9885),CHAR(11036))

⚝

CHAR IF

Yes / No with Outlined White Star and White Small Square blank

Put Yes in A1 for outlined white star. Anything else shows white small square.

=IF(A1="Yes",CHAR(9885),CHAR(9643))

⚝

CHAR IF

Yes / No with Outlined White Star and White Medium Square blank

Put Yes in A1 for outlined white star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(9885),CHAR(9723))

⚝

CHAR IF

Yes / No with Outlined White Star and Dotted Line Face blank

Put Yes in A1 for outlined white star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(9885),UNICHAR(129509))

⚝

CHAR UNICHAR IF

Yes / No with Outlined White Star and Prohibited blank

Put Yes in A1 for outlined white star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(9885),UNICHAR(128683))

⚝

CHAR UNICHAR IF

Yes / No with Outlined White Star and Black Large Square blank

Put Yes in A1 for outlined white star. Anything else shows black large square.

=IF(A1="Yes",CHAR(9885),CHAR(11035))

⚝

CHAR IF

Yes / No with Outlined White Star and Black Square Button blank

Put Yes in A1 for outlined white star. Anything else shows black square button.

=IF(A1="Yes",CHAR(9885),UNICHAR(128274))

⚝

CHAR UNICHAR IF

Yes / No with Outlined White Star and Black Small Square blank

Put Yes in A1 for outlined white star. Anything else shows black small square.

=IF(A1="Yes",CHAR(9885),CHAR(9642))

⚝

CHAR IF

Yes / No with Outlined White Star and Black Medium Small Square blank

Put Yes in A1 for outlined white star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(9885),CHAR(9726))

⚝

CHAR IF

Yes / No with Outlined White Star and White Square Button blank

Put Yes in A1 for outlined white star. Anything else shows white square button.

=IF(A1="Yes",CHAR(9885),UNICHAR(128275))

⚝

CHAR UNICHAR IF

Yes / No with Outlined White Star and White Square with Rounded Corners blank

Put Yes in A1 for outlined white star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(9885),CHAR(9634))

⚝

CHAR IF

Yes / No with Outlined White Star and White Circle blank

Put Yes in A1 for outlined white star. Anything else shows white circle.

=IF(A1="Yes",CHAR(9885),CHAR(9898))

⚝

CHAR IF

Yes / No with Black Four Pointed Star and New Moon blank

Put Yes in A1 for black four pointed star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10022),UNICHAR(127761))

✦

CHAR UNICHAR IF

Yes / No with Black Four Pointed Star and White Large Square blank

Put Yes in A1 for black four pointed star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10022),CHAR(11036))

✦

CHAR IF

Yes / No with Black Four Pointed Star and White Small Square blank

Put Yes in A1 for black four pointed star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10022),CHAR(9643))

✦

CHAR IF

Yes / No with Black Four Pointed Star and White Medium Square blank

Put Yes in A1 for black four pointed star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10022),CHAR(9723))

✦

CHAR IF

Yes / No with Black Four Pointed Star and Dotted Line Face blank

Put Yes in A1 for black four pointed star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10022),UNICHAR(129509))

✦

CHAR UNICHAR IF

Yes / No with Black Four Pointed Star and Prohibited blank

Put Yes in A1 for black four pointed star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10022),UNICHAR(128683))

✦

CHAR UNICHAR IF

Yes / No with Black Four Pointed Star and Black Large Square blank

Put Yes in A1 for black four pointed star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10022),CHAR(11035))

✦

CHAR IF

Yes / No with Black Four Pointed Star and Black Square Button blank

Put Yes in A1 for black four pointed star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10022),UNICHAR(128274))

✦

CHAR UNICHAR IF

Yes / No with Black Four Pointed Star and Black Small Square blank

Put Yes in A1 for black four pointed star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10022),CHAR(9642))

✦

CHAR IF

Yes / No with Black Four Pointed Star and Black Medium Small Square blank

Put Yes in A1 for black four pointed star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10022),CHAR(9726))

✦

CHAR IF

Yes / No with Black Four Pointed Star and White Square Button blank

Put Yes in A1 for black four pointed star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10022),UNICHAR(128275))

✦

CHAR UNICHAR IF

Yes / No with Black Four Pointed Star and White Square with Rounded Corners blank

Put Yes in A1 for black four pointed star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10022),CHAR(9634))

✦

CHAR IF

Yes / No with Black Four Pointed Star and White Circle blank

Put Yes in A1 for black four pointed star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10022),CHAR(9898))

✦

CHAR IF

Yes / No with White Four Pointed Star and New Moon blank

Put Yes in A1 for white four pointed star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10023),UNICHAR(127761))

✧

CHAR UNICHAR IF

Yes / No with White Four Pointed Star and White Large Square blank

Put Yes in A1 for white four pointed star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10023),CHAR(11036))

✧

CHAR IF

Yes / No with White Four Pointed Star and White Small Square blank

Put Yes in A1 for white four pointed star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10023),CHAR(9643))

✧

CHAR IF

Yes / No with White Four Pointed Star and White Medium Square blank

Put Yes in A1 for white four pointed star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10023),CHAR(9723))

✧

CHAR IF

Yes / No with White Four Pointed Star and Dotted Line Face blank

Put Yes in A1 for white four pointed star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10023),UNICHAR(129509))

✧

CHAR UNICHAR IF

Yes / No with White Four Pointed Star and Prohibited blank

Put Yes in A1 for white four pointed star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10023),UNICHAR(128683))

✧

CHAR UNICHAR IF

Yes / No with White Four Pointed Star and Black Large Square blank

Put Yes in A1 for white four pointed star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10023),CHAR(11035))

✧

CHAR IF

Yes / No with White Four Pointed Star and Black Square Button blank

Put Yes in A1 for white four pointed star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10023),UNICHAR(128274))

✧

CHAR UNICHAR IF

Yes / No with White Four Pointed Star and Black Small Square blank

Put Yes in A1 for white four pointed star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10023),CHAR(9642))

✧

CHAR IF

Yes / No with White Four Pointed Star and Black Medium Small Square blank

Put Yes in A1 for white four pointed star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10023),CHAR(9726))

✧

CHAR IF

Yes / No with White Four Pointed Star and White Square Button blank

Put Yes in A1 for white four pointed star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10023),UNICHAR(128275))

✧

CHAR UNICHAR IF

Yes / No with White Four Pointed Star and White Square with Rounded Corners blank

Put Yes in A1 for white four pointed star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10023),CHAR(9634))

✧

CHAR IF

Yes / No with White Four Pointed Star and White Circle blank

Put Yes in A1 for white four pointed star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10023),CHAR(9898))

✧

CHAR IF

Yes / No with Stress Outlined White Star and New Moon blank

Put Yes in A1 for stress outlined white star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10025),UNICHAR(127761))

✩

CHAR UNICHAR IF

Yes / No with Stress Outlined White Star and White Large Square blank

Put Yes in A1 for stress outlined white star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10025),CHAR(11036))

✩

CHAR IF

Yes / No with Stress Outlined White Star and White Small Square blank

Put Yes in A1 for stress outlined white star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10025),CHAR(9643))

✩

CHAR IF

Yes / No with Stress Outlined White Star and White Medium Square blank

Put Yes in A1 for stress outlined white star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10025),CHAR(9723))

✩

CHAR IF

Yes / No with Stress Outlined White Star and Dotted Line Face blank

Put Yes in A1 for stress outlined white star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10025),UNICHAR(129509))

✩

CHAR UNICHAR IF

Yes / No with Stress Outlined White Star and Prohibited blank

Put Yes in A1 for stress outlined white star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10025),UNICHAR(128683))

✩

CHAR UNICHAR IF

Yes / No with Stress Outlined White Star and Black Large Square blank

Put Yes in A1 for stress outlined white star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10025),CHAR(11035))

✩

CHAR IF

Yes / No with Stress Outlined White Star and Black Square Button blank

Put Yes in A1 for stress outlined white star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10025),UNICHAR(128274))

✩

CHAR UNICHAR IF

Yes / No with Stress Outlined White Star and Black Small Square blank

Put Yes in A1 for stress outlined white star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10025),CHAR(9642))

✩

CHAR IF

Yes / No with Stress Outlined White Star and Black Medium Small Square blank

Put Yes in A1 for stress outlined white star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10025),CHAR(9726))

✩

CHAR IF

Yes / No with Stress Outlined White Star and White Square Button blank

Put Yes in A1 for stress outlined white star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10025),UNICHAR(128275))

✩

CHAR UNICHAR IF

Yes / No with Stress Outlined White Star and White Square with Rounded Corners blank

Put Yes in A1 for stress outlined white star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10025),CHAR(9634))

✩

CHAR IF

Yes / No with Stress Outlined White Star and White Circle blank

Put Yes in A1 for stress outlined white star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10025),CHAR(9898))

✩

CHAR IF

Yes / No with Circled White Star and New Moon blank

Put Yes in A1 for circled white star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10026),UNICHAR(127761))

✪

CHAR UNICHAR IF

Yes / No with Circled White Star and White Large Square blank

Put Yes in A1 for circled white star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10026),CHAR(11036))

✪

CHAR IF

Yes / No with Circled White Star and White Small Square blank

Put Yes in A1 for circled white star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10026),CHAR(9643))

✪

CHAR IF

Yes / No with Circled White Star and White Medium Square blank

Put Yes in A1 for circled white star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10026),CHAR(9723))

✪

CHAR IF

Yes / No with Circled White Star and Dotted Line Face blank

Put Yes in A1 for circled white star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10026),UNICHAR(129509))

✪

CHAR UNICHAR IF

Yes / No with Circled White Star and Prohibited blank

Put Yes in A1 for circled white star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10026),UNICHAR(128683))

✪

CHAR UNICHAR IF

Yes / No with Circled White Star and Black Large Square blank

Put Yes in A1 for circled white star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10026),CHAR(11035))

✪

CHAR IF

Yes / No with Circled White Star and Black Square Button blank

Put Yes in A1 for circled white star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10026),UNICHAR(128274))

✪

CHAR UNICHAR IF

Yes / No with Circled White Star and Black Small Square blank

Put Yes in A1 for circled white star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10026),CHAR(9642))

✪

CHAR IF

Yes / No with Circled White Star and Black Medium Small Square blank

Put Yes in A1 for circled white star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10026),CHAR(9726))

✪

CHAR IF

Yes / No with Circled White Star and White Square Button blank

Put Yes in A1 for circled white star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10026),UNICHAR(128275))

✪

CHAR UNICHAR IF

Yes / No with Circled White Star and White Square with Rounded Corners blank

Put Yes in A1 for circled white star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10026),CHAR(9634))

✪

CHAR IF

Yes / No with Circled White Star and White Circle blank

Put Yes in A1 for circled white star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10026),CHAR(9898))

✪

CHAR IF

Yes / No with Open Centre Black Star and New Moon blank

Put Yes in A1 for open centre black star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10027),UNICHAR(127761))

✫

CHAR UNICHAR IF

Yes / No with Open Centre Black Star and White Large Square blank

Put Yes in A1 for open centre black star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10027),CHAR(11036))

✫

CHAR IF

Yes / No with Open Centre Black Star and White Small Square blank

Put Yes in A1 for open centre black star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10027),CHAR(9643))

✫

CHAR IF

Yes / No with Open Centre Black Star and White Medium Square blank

Put Yes in A1 for open centre black star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10027),CHAR(9723))

✫

CHAR IF

Yes / No with Open Centre Black Star and Dotted Line Face blank

Put Yes in A1 for open centre black star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10027),UNICHAR(129509))

✫

CHAR UNICHAR IF

Yes / No with Open Centre Black Star and Prohibited blank

Put Yes in A1 for open centre black star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10027),UNICHAR(128683))

✫

CHAR UNICHAR IF

Yes / No with Open Centre Black Star and Black Large Square blank

Put Yes in A1 for open centre black star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10027),CHAR(11035))

✫

CHAR IF

Yes / No with Open Centre Black Star and Black Square Button blank

Put Yes in A1 for open centre black star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10027),UNICHAR(128274))

✫

CHAR UNICHAR IF

Yes / No with Open Centre Black Star and Black Small Square blank

Put Yes in A1 for open centre black star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10027),CHAR(9642))

✫

CHAR IF

Yes / No with Open Centre Black Star and Black Medium Small Square blank

Put Yes in A1 for open centre black star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10027),CHAR(9726))

✫

CHAR IF

Yes / No with Open Centre Black Star and White Square Button blank

Put Yes in A1 for open centre black star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10027),UNICHAR(128275))

✫

CHAR UNICHAR IF

Yes / No with Open Centre Black Star and White Square with Rounded Corners blank

Put Yes in A1 for open centre black star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10027),CHAR(9634))

✫

CHAR IF

Yes / No with Open Centre Black Star and White Circle blank

Put Yes in A1 for open centre black star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10027),CHAR(9898))

✫

CHAR IF

Yes / No with Black Centre White Star and New Moon blank

Put Yes in A1 for black centre white star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10028),UNICHAR(127761))

✬

CHAR UNICHAR IF

Yes / No with Black Centre White Star and White Large Square blank

Put Yes in A1 for black centre white star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10028),CHAR(11036))

✬

CHAR IF

Yes / No with Black Centre White Star and White Small Square blank

Put Yes in A1 for black centre white star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10028),CHAR(9643))

✬

CHAR IF

Yes / No with Black Centre White Star and White Medium Square blank

Put Yes in A1 for black centre white star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10028),CHAR(9723))

✬

CHAR IF

Yes / No with Black Centre White Star and Dotted Line Face blank

Put Yes in A1 for black centre white star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10028),UNICHAR(129509))

✬

CHAR UNICHAR IF

Yes / No with Black Centre White Star and Prohibited blank

Put Yes in A1 for black centre white star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10028),UNICHAR(128683))

✬

CHAR UNICHAR IF

Yes / No with Black Centre White Star and Black Large Square blank

Put Yes in A1 for black centre white star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10028),CHAR(11035))

✬

CHAR IF

Yes / No with Black Centre White Star and Black Square Button blank

Put Yes in A1 for black centre white star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10028),UNICHAR(128274))

✬

CHAR UNICHAR IF

Yes / No with Black Centre White Star and Black Small Square blank

Put Yes in A1 for black centre white star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10028),CHAR(9642))

✬

CHAR IF

Yes / No with Black Centre White Star and Black Medium Small Square blank

Put Yes in A1 for black centre white star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10028),CHAR(9726))

✬

CHAR IF

Yes / No with Black Centre White Star and White Square Button blank

Put Yes in A1 for black centre white star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10028),UNICHAR(128275))

✬

CHAR UNICHAR IF

Yes / No with Black Centre White Star and White Square with Rounded Corners blank

Put Yes in A1 for black centre white star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10028),CHAR(9634))

✬

CHAR IF

Yes / No with Black Centre White Star and White Circle blank

Put Yes in A1 for black centre white star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10028),CHAR(9898))

✬

CHAR IF

Yes / No with Outlined Black Star and New Moon blank

Put Yes in A1 for outlined black star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10029),UNICHAR(127761))

✭

CHAR UNICHAR IF

Yes / No with Outlined Black Star and White Large Square blank

Put Yes in A1 for outlined black star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10029),CHAR(11036))

✭

CHAR IF

Yes / No with Outlined Black Star and White Small Square blank

Put Yes in A1 for outlined black star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10029),CHAR(9643))

✭

CHAR IF

Yes / No with Outlined Black Star and White Medium Square blank

Put Yes in A1 for outlined black star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10029),CHAR(9723))

✭

CHAR IF

Yes / No with Outlined Black Star and Dotted Line Face blank

Put Yes in A1 for outlined black star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10029),UNICHAR(129509))

✭

CHAR UNICHAR IF

Yes / No with Outlined Black Star and Prohibited blank

Put Yes in A1 for outlined black star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10029),UNICHAR(128683))

✭

CHAR UNICHAR IF

Yes / No with Outlined Black Star and Black Large Square blank

Put Yes in A1 for outlined black star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10029),CHAR(11035))

✭

CHAR IF

Yes / No with Outlined Black Star and Black Square Button blank

Put Yes in A1 for outlined black star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10029),UNICHAR(128274))

✭

CHAR UNICHAR IF

Yes / No with Outlined Black Star and Black Small Square blank

Put Yes in A1 for outlined black star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10029),CHAR(9642))

✭

CHAR IF

Yes / No with Outlined Black Star and Black Medium Small Square blank

Put Yes in A1 for outlined black star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10029),CHAR(9726))

✭

CHAR IF

Yes / No with Outlined Black Star and White Square Button blank

Put Yes in A1 for outlined black star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10029),UNICHAR(128275))

✭

CHAR UNICHAR IF

Yes / No with Outlined Black Star and White Square with Rounded Corners blank

Put Yes in A1 for outlined black star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10029),CHAR(9634))

✭

CHAR IF

Yes / No with Outlined Black Star and White Circle blank

Put Yes in A1 for outlined black star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10029),CHAR(9898))

✭

CHAR IF

Yes / No with Heavy Outlined Black Star and New Moon blank

Put Yes in A1 for heavy outlined black star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10030),UNICHAR(127761))

✮

CHAR UNICHAR IF

Yes / No with Heavy Outlined Black Star and White Large Square blank

Put Yes in A1 for heavy outlined black star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10030),CHAR(11036))

✮

CHAR IF

Yes / No with Heavy Outlined Black Star and White Small Square blank

Put Yes in A1 for heavy outlined black star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10030),CHAR(9643))

✮

CHAR IF

Yes / No with Heavy Outlined Black Star and White Medium Square blank

Put Yes in A1 for heavy outlined black star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10030),CHAR(9723))

✮

CHAR IF

Yes / No with Heavy Outlined Black Star and Dotted Line Face blank

Put Yes in A1 for heavy outlined black star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10030),UNICHAR(129509))

✮

CHAR UNICHAR IF

Yes / No with Heavy Outlined Black Star and Prohibited blank

Put Yes in A1 for heavy outlined black star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10030),UNICHAR(128683))

✮

CHAR UNICHAR IF

Yes / No with Heavy Outlined Black Star and Black Large Square blank

Put Yes in A1 for heavy outlined black star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10030),CHAR(11035))

✮

CHAR IF

Yes / No with Heavy Outlined Black Star and Black Square Button blank

Put Yes in A1 for heavy outlined black star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10030),UNICHAR(128274))

✮

CHAR UNICHAR IF

Yes / No with Heavy Outlined Black Star and Black Small Square blank

Put Yes in A1 for heavy outlined black star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10030),CHAR(9642))

✮

CHAR IF

Yes / No with Heavy Outlined Black Star and Black Medium Small Square blank

Put Yes in A1 for heavy outlined black star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10030),CHAR(9726))

✮

CHAR IF

Yes / No with Heavy Outlined Black Star and White Square Button blank

Put Yes in A1 for heavy outlined black star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10030),UNICHAR(128275))

✮

CHAR UNICHAR IF

Yes / No with Heavy Outlined Black Star and White Square with Rounded Corners blank

Put Yes in A1 for heavy outlined black star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10030),CHAR(9634))

✮

CHAR IF

Yes / No with Heavy Outlined Black Star and White Circle blank

Put Yes in A1 for heavy outlined black star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10030),CHAR(9898))

✮

CHAR IF

Yes / No with Pinwheel Star and New Moon blank

Put Yes in A1 for pinwheel star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10031),UNICHAR(127761))

✯

CHAR UNICHAR IF

Yes / No with Pinwheel Star and White Large Square blank

Put Yes in A1 for pinwheel star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10031),CHAR(11036))

✯

CHAR IF

Yes / No with Pinwheel Star and White Small Square blank

Put Yes in A1 for pinwheel star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10031),CHAR(9643))

✯

CHAR IF

Yes / No with Pinwheel Star and White Medium Square blank

Put Yes in A1 for pinwheel star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10031),CHAR(9723))

✯

CHAR IF

Yes / No with Pinwheel Star and Dotted Line Face blank

Put Yes in A1 for pinwheel star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10031),UNICHAR(129509))

✯

CHAR UNICHAR IF

Yes / No with Pinwheel Star and Prohibited blank

Put Yes in A1 for pinwheel star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10031),UNICHAR(128683))

✯

CHAR UNICHAR IF

Yes / No with Pinwheel Star and Black Large Square blank

Put Yes in A1 for pinwheel star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10031),CHAR(11035))

✯

CHAR IF

Yes / No with Pinwheel Star and Black Square Button blank

Put Yes in A1 for pinwheel star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10031),UNICHAR(128274))

✯

CHAR UNICHAR IF

Yes / No with Pinwheel Star and Black Small Square blank

Put Yes in A1 for pinwheel star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10031),CHAR(9642))

✯

CHAR IF

Yes / No with Pinwheel Star and Black Medium Small Square blank

Put Yes in A1 for pinwheel star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10031),CHAR(9726))

✯

CHAR IF

Yes / No with Pinwheel Star and White Square Button blank

Put Yes in A1 for pinwheel star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10031),UNICHAR(128275))

✯

CHAR UNICHAR IF

Yes / No with Pinwheel Star and White Square with Rounded Corners blank

Put Yes in A1 for pinwheel star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10031),CHAR(9634))

✯

CHAR IF

Yes / No with Pinwheel Star and White Circle blank

Put Yes in A1 for pinwheel star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10031),CHAR(9898))

✯

CHAR IF

Yes / No with Shadowed White Star and New Moon blank

Put Yes in A1 for shadowed white star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10032),UNICHAR(127761))

✰

CHAR UNICHAR IF

Yes / No with Shadowed White Star and White Large Square blank

Put Yes in A1 for shadowed white star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10032),CHAR(11036))

✰

CHAR IF

Yes / No with Shadowed White Star and White Small Square blank

Put Yes in A1 for shadowed white star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10032),CHAR(9643))

✰

CHAR IF

Yes / No with Shadowed White Star and White Medium Square blank

Put Yes in A1 for shadowed white star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10032),CHAR(9723))

✰

CHAR IF

Yes / No with Shadowed White Star and Dotted Line Face blank

Put Yes in A1 for shadowed white star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10032),UNICHAR(129509))

✰

CHAR UNICHAR IF

Yes / No with Shadowed White Star and Prohibited blank

Put Yes in A1 for shadowed white star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10032),UNICHAR(128683))

✰

CHAR UNICHAR IF

Yes / No with Shadowed White Star and Black Large Square blank

Put Yes in A1 for shadowed white star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10032),CHAR(11035))

✰

CHAR IF

Yes / No with Shadowed White Star and Black Square Button blank

Put Yes in A1 for shadowed white star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10032),UNICHAR(128274))

✰

CHAR UNICHAR IF

Yes / No with Shadowed White Star and Black Small Square blank

Put Yes in A1 for shadowed white star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10032),CHAR(9642))

✰

CHAR IF

Yes / No with Shadowed White Star and Black Medium Small Square blank

Put Yes in A1 for shadowed white star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10032),CHAR(9726))

✰

CHAR IF

Yes / No with Shadowed White Star and White Square Button blank

Put Yes in A1 for shadowed white star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10032),UNICHAR(128275))

✰

CHAR UNICHAR IF

Yes / No with Shadowed White Star and White Square with Rounded Corners blank

Put Yes in A1 for shadowed white star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10032),CHAR(9634))

✰

CHAR IF

Yes / No with Shadowed White Star and White Circle blank

Put Yes in A1 for shadowed white star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10032),CHAR(9898))

✰

CHAR IF

Yes / No with Eight Pointed Black Star and New Moon blank

Put Yes in A1 for eight pointed black star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10036),UNICHAR(127761))

✴

CHAR UNICHAR IF

Yes / No with Eight Pointed Black Star and White Large Square blank

Put Yes in A1 for eight pointed black star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10036),CHAR(11036))

✴

CHAR IF

Yes / No with Eight Pointed Black Star and White Small Square blank

Put Yes in A1 for eight pointed black star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10036),CHAR(9643))

✴

CHAR IF

Yes / No with Eight Pointed Black Star and White Medium Square blank

Put Yes in A1 for eight pointed black star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10036),CHAR(9723))

✴

CHAR IF

Yes / No with Eight Pointed Black Star and Dotted Line Face blank

Put Yes in A1 for eight pointed black star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10036),UNICHAR(129509))

✴

CHAR UNICHAR IF

Yes / No with Eight Pointed Black Star and Prohibited blank

Put Yes in A1 for eight pointed black star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10036),UNICHAR(128683))

✴

CHAR UNICHAR IF

Yes / No with Eight Pointed Black Star and Black Large Square blank

Put Yes in A1 for eight pointed black star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10036),CHAR(11035))

✴

CHAR IF

Yes / No with Eight Pointed Black Star and Black Square Button blank

Put Yes in A1 for eight pointed black star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10036),UNICHAR(128274))

✴

CHAR UNICHAR IF

Yes / No with Eight Pointed Black Star and Black Small Square blank

Put Yes in A1 for eight pointed black star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10036),CHAR(9642))

✴

CHAR IF

Yes / No with Eight Pointed Black Star and Black Medium Small Square blank

Put Yes in A1 for eight pointed black star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10036),CHAR(9726))

✴

CHAR IF

Yes / No with Eight Pointed Black Star and White Square Button blank

Put Yes in A1 for eight pointed black star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10036),UNICHAR(128275))

✴

CHAR UNICHAR IF

Yes / No with Eight Pointed Black Star and White Square with Rounded Corners blank

Put Yes in A1 for eight pointed black star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10036),CHAR(9634))

✴

CHAR IF

Yes / No with Eight Pointed Black Star and White Circle blank

Put Yes in A1 for eight pointed black star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10036),CHAR(9898))

✴

CHAR IF

Yes / No with Eight Pointed Pinwheel Star and New Moon blank

Put Yes in A1 for eight pointed pinwheel star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10037),UNICHAR(127761))

✵

CHAR UNICHAR IF

Yes / No with Eight Pointed Pinwheel Star and White Large Square blank

Put Yes in A1 for eight pointed pinwheel star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10037),CHAR(11036))

✵

CHAR IF

Yes / No with Eight Pointed Pinwheel Star and White Small Square blank

Put Yes in A1 for eight pointed pinwheel star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10037),CHAR(9643))

✵

CHAR IF

Yes / No with Eight Pointed Pinwheel Star and White Medium Square blank

Put Yes in A1 for eight pointed pinwheel star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10037),CHAR(9723))

✵

CHAR IF

Yes / No with Eight Pointed Pinwheel Star and Dotted Line Face blank

Put Yes in A1 for eight pointed pinwheel star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10037),UNICHAR(129509))

✵

CHAR UNICHAR IF

Yes / No with Eight Pointed Pinwheel Star and Prohibited blank

Put Yes in A1 for eight pointed pinwheel star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10037),UNICHAR(128683))

✵

CHAR UNICHAR IF

Yes / No with Eight Pointed Pinwheel Star and Black Large Square blank

Put Yes in A1 for eight pointed pinwheel star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10037),CHAR(11035))

✵

CHAR IF

Yes / No with Eight Pointed Pinwheel Star and Black Square Button blank

Put Yes in A1 for eight pointed pinwheel star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10037),UNICHAR(128274))

✵

CHAR UNICHAR IF

Yes / No with Eight Pointed Pinwheel Star and Black Small Square blank

Put Yes in A1 for eight pointed pinwheel star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10037),CHAR(9642))

✵

CHAR IF

Yes / No with Eight Pointed Pinwheel Star and Black Medium Small Square blank

Put Yes in A1 for eight pointed pinwheel star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10037),CHAR(9726))

✵

CHAR IF

Yes / No with Eight Pointed Pinwheel Star and White Square Button blank

Put Yes in A1 for eight pointed pinwheel star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10037),UNICHAR(128275))

✵

CHAR UNICHAR IF

Yes / No with Eight Pointed Pinwheel Star and White Square with Rounded Corners blank

Put Yes in A1 for eight pointed pinwheel star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10037),CHAR(9634))

✵

CHAR IF

Yes / No with Eight Pointed Pinwheel Star and White Circle blank

Put Yes in A1 for eight pointed pinwheel star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10037),CHAR(9898))

✵

CHAR IF

Yes / No with Six Pointed Black Star and New Moon blank

Put Yes in A1 for six pointed black star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10038),UNICHAR(127761))

✶

CHAR UNICHAR IF

Yes / No with Six Pointed Black Star and White Large Square blank

Put Yes in A1 for six pointed black star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10038),CHAR(11036))

✶

CHAR IF

Yes / No with Six Pointed Black Star and White Small Square blank

Put Yes in A1 for six pointed black star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10038),CHAR(9643))

✶

CHAR IF

Yes / No with Six Pointed Black Star and White Medium Square blank

Put Yes in A1 for six pointed black star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10038),CHAR(9723))

✶

CHAR IF

Yes / No with Six Pointed Black Star and Dotted Line Face blank

Put Yes in A1 for six pointed black star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10038),UNICHAR(129509))

✶

CHAR UNICHAR IF

Yes / No with Six Pointed Black Star and Prohibited blank

Put Yes in A1 for six pointed black star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10038),UNICHAR(128683))

✶

CHAR UNICHAR IF

Yes / No with Six Pointed Black Star and Black Large Square blank

Put Yes in A1 for six pointed black star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10038),CHAR(11035))

✶

CHAR IF

Yes / No with Six Pointed Black Star and Black Square Button blank

Put Yes in A1 for six pointed black star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10038),UNICHAR(128274))

✶

CHAR UNICHAR IF

Yes / No with Six Pointed Black Star and Black Small Square blank

Put Yes in A1 for six pointed black star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10038),CHAR(9642))

✶

CHAR IF

Yes / No with Six Pointed Black Star and Black Medium Small Square blank

Put Yes in A1 for six pointed black star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10038),CHAR(9726))

✶

CHAR IF

Yes / No with Six Pointed Black Star and White Square Button blank

Put Yes in A1 for six pointed black star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10038),UNICHAR(128275))

✶

CHAR UNICHAR IF

Yes / No with Six Pointed Black Star and White Square with Rounded Corners blank

Put Yes in A1 for six pointed black star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10038),CHAR(9634))

✶

CHAR IF

Yes / No with Six Pointed Black Star and White Circle blank

Put Yes in A1 for six pointed black star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10038),CHAR(9898))

✶

CHAR IF

Yes / No with Eight Pointed Rectilinear Black Star and New Moon blank

Put Yes in A1 for eight pointed rectilinear black star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10039),UNICHAR(127761))

✷

CHAR UNICHAR IF

Yes / No with Eight Pointed Rectilinear Black Star and White Large Square blank

Put Yes in A1 for eight pointed rectilinear black star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10039),CHAR(11036))

✷

CHAR IF

Yes / No with Eight Pointed Rectilinear Black Star and White Small Square blank

Put Yes in A1 for eight pointed rectilinear black star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10039),CHAR(9643))

✷

CHAR IF

Yes / No with Eight Pointed Rectilinear Black Star and White Medium Square blank

Put Yes in A1 for eight pointed rectilinear black star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10039),CHAR(9723))

✷

CHAR IF

Yes / No with Eight Pointed Rectilinear Black Star and Dotted Line Face blank

Put Yes in A1 for eight pointed rectilinear black star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10039),UNICHAR(129509))

✷

CHAR UNICHAR IF

Yes / No with Eight Pointed Rectilinear Black Star and Prohibited blank

Put Yes in A1 for eight pointed rectilinear black star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10039),UNICHAR(128683))

✷

CHAR UNICHAR IF

Yes / No with Eight Pointed Rectilinear Black Star and Black Large Square blank

Put Yes in A1 for eight pointed rectilinear black star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10039),CHAR(11035))

✷

CHAR IF

Yes / No with Eight Pointed Rectilinear Black Star and Black Square Button blank

Put Yes in A1 for eight pointed rectilinear black star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10039),UNICHAR(128274))

✷

CHAR UNICHAR IF

Yes / No with Eight Pointed Rectilinear Black Star and Black Small Square blank

Put Yes in A1 for eight pointed rectilinear black star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10039),CHAR(9642))

✷

CHAR IF

Yes / No with Eight Pointed Rectilinear Black Star and Black Medium Small Square blank

Put Yes in A1 for eight pointed rectilinear black star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10039),CHAR(9726))

✷

CHAR IF

Yes / No with Eight Pointed Rectilinear Black Star and White Square Button blank

Put Yes in A1 for eight pointed rectilinear black star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10039),UNICHAR(128275))

✷

CHAR UNICHAR IF

Yes / No with Eight Pointed Rectilinear Black Star and White Square with Rounded Corners blank

Put Yes in A1 for eight pointed rectilinear black star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10039),CHAR(9634))

✷

CHAR IF

Yes / No with Eight Pointed Rectilinear Black Star and White Circle blank

Put Yes in A1 for eight pointed rectilinear black star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10039),CHAR(9898))

✷

CHAR IF

Yes / No with Heavy Eight Pointed Rectilinear Black Star and New Moon blank

Put Yes in A1 for heavy eight pointed rectilinear black star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10040),UNICHAR(127761))

✸

CHAR UNICHAR IF

Yes / No with Heavy Eight Pointed Rectilinear Black Star and White Large Square blank

Put Yes in A1 for heavy eight pointed rectilinear black star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10040),CHAR(11036))

✸

CHAR IF

Yes / No with Heavy Eight Pointed Rectilinear Black Star and White Small Square blank

Put Yes in A1 for heavy eight pointed rectilinear black star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10040),CHAR(9643))

✸

CHAR IF

Yes / No with Heavy Eight Pointed Rectilinear Black Star and White Medium Square blank

Put Yes in A1 for heavy eight pointed rectilinear black star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10040),CHAR(9723))

✸

CHAR IF

Yes / No with Heavy Eight Pointed Rectilinear Black Star and Dotted Line Face blank

Put Yes in A1 for heavy eight pointed rectilinear black star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10040),UNICHAR(129509))

✸

CHAR UNICHAR IF

Yes / No with Heavy Eight Pointed Rectilinear Black Star and Prohibited blank

Put Yes in A1 for heavy eight pointed rectilinear black star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10040),UNICHAR(128683))

✸

CHAR UNICHAR IF

Yes / No with Heavy Eight Pointed Rectilinear Black Star and Black Large Square blank

Put Yes in A1 for heavy eight pointed rectilinear black star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10040),CHAR(11035))

✸

CHAR IF

Yes / No with Heavy Eight Pointed Rectilinear Black Star and Black Square Button blank

Put Yes in A1 for heavy eight pointed rectilinear black star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10040),UNICHAR(128274))

✸

CHAR UNICHAR IF

Yes / No with Heavy Eight Pointed Rectilinear Black Star and Black Small Square blank

Put Yes in A1 for heavy eight pointed rectilinear black star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10040),CHAR(9642))

✸

CHAR IF

Yes / No with Heavy Eight Pointed Rectilinear Black Star and Black Medium Small Square blank

Put Yes in A1 for heavy eight pointed rectilinear black star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10040),CHAR(9726))

✸

CHAR IF

Yes / No with Heavy Eight Pointed Rectilinear Black Star and White Square Button blank

Put Yes in A1 for heavy eight pointed rectilinear black star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10040),UNICHAR(128275))

✸

CHAR UNICHAR IF

Yes / No with Heavy Eight Pointed Rectilinear Black Star and White Square with Rounded Corners blank

Put Yes in A1 for heavy eight pointed rectilinear black star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10040),CHAR(9634))

✸

CHAR IF

Yes / No with Heavy Eight Pointed Rectilinear Black Star and White Circle blank

Put Yes in A1 for heavy eight pointed rectilinear black star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10040),CHAR(9898))

✸

CHAR IF

Yes / No with Twelve Pointed Black Star and New Moon blank

Put Yes in A1 for twelve pointed black star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10041),UNICHAR(127761))

✹

CHAR UNICHAR IF

Yes / No with Twelve Pointed Black Star and White Large Square blank

Put Yes in A1 for twelve pointed black star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10041),CHAR(11036))

✹

CHAR IF

Yes / No with Twelve Pointed Black Star and White Small Square blank

Put Yes in A1 for twelve pointed black star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10041),CHAR(9643))

✹

CHAR IF

Yes / No with Twelve Pointed Black Star and White Medium Square blank

Put Yes in A1 for twelve pointed black star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10041),CHAR(9723))

✹

CHAR IF

Yes / No with Twelve Pointed Black Star and Dotted Line Face blank

Put Yes in A1 for twelve pointed black star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10041),UNICHAR(129509))

✹

CHAR UNICHAR IF

Yes / No with Twelve Pointed Black Star and Prohibited blank

Put Yes in A1 for twelve pointed black star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10041),UNICHAR(128683))

✹

CHAR UNICHAR IF

Yes / No with Twelve Pointed Black Star and Black Large Square blank

Put Yes in A1 for twelve pointed black star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10041),CHAR(11035))

✹

CHAR IF

Yes / No with Twelve Pointed Black Star and Black Square Button blank

Put Yes in A1 for twelve pointed black star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10041),UNICHAR(128274))

✹

CHAR UNICHAR IF

Yes / No with Twelve Pointed Black Star and Black Small Square blank

Put Yes in A1 for twelve pointed black star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10041),CHAR(9642))

✹

CHAR IF

Yes / No with Twelve Pointed Black Star and Black Medium Small Square blank

Put Yes in A1 for twelve pointed black star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10041),CHAR(9726))

✹

CHAR IF

Yes / No with Twelve Pointed Black Star and White Square Button blank

Put Yes in A1 for twelve pointed black star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10041),UNICHAR(128275))

✹

CHAR UNICHAR IF

Yes / No with Twelve Pointed Black Star and White Square with Rounded Corners blank

Put Yes in A1 for twelve pointed black star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10041),CHAR(9634))

✹

CHAR IF

Yes / No with Twelve Pointed Black Star and White Circle blank

Put Yes in A1 for twelve pointed black star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10041),CHAR(9898))

✹

CHAR IF

Yes / No with Circled Open Centre Eight Pointed Star and New Moon blank

Put Yes in A1 for circled open centre eight pointed star. Anything else shows new moon.

=IF(A1="Yes",CHAR(10050),UNICHAR(127761))

❂

CHAR UNICHAR IF

Yes / No with Circled Open Centre Eight Pointed Star and White Large Square blank

Put Yes in A1 for circled open centre eight pointed star. Anything else shows white large square.

=IF(A1="Yes",CHAR(10050),CHAR(11036))

❂

CHAR IF

Yes / No with Circled Open Centre Eight Pointed Star and White Small Square blank

Put Yes in A1 for circled open centre eight pointed star. Anything else shows white small square.

=IF(A1="Yes",CHAR(10050),CHAR(9643))

❂

CHAR IF

Yes / No with Circled Open Centre Eight Pointed Star and White Medium Square blank

Put Yes in A1 for circled open centre eight pointed star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(10050),CHAR(9723))

❂

CHAR IF

Yes / No with Circled Open Centre Eight Pointed Star and Dotted Line Face blank

Put Yes in A1 for circled open centre eight pointed star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(10050),UNICHAR(129509))

❂

CHAR UNICHAR IF

Yes / No with Circled Open Centre Eight Pointed Star and Prohibited blank

Put Yes in A1 for circled open centre eight pointed star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(10050),UNICHAR(128683))

❂

CHAR UNICHAR IF

Yes / No with Circled Open Centre Eight Pointed Star and Black Large Square blank

Put Yes in A1 for circled open centre eight pointed star. Anything else shows black large square.

=IF(A1="Yes",CHAR(10050),CHAR(11035))

❂

CHAR IF

Yes / No with Circled Open Centre Eight Pointed Star and Black Square Button blank

Put Yes in A1 for circled open centre eight pointed star. Anything else shows black square button.

=IF(A1="Yes",CHAR(10050),UNICHAR(128274))

❂

CHAR UNICHAR IF

Yes / No with Circled Open Centre Eight Pointed Star and Black Small Square blank

Put Yes in A1 for circled open centre eight pointed star. Anything else shows black small square.

=IF(A1="Yes",CHAR(10050),CHAR(9642))

❂

CHAR IF

Yes / No with Circled Open Centre Eight Pointed Star and Black Medium Small Square blank

Put Yes in A1 for circled open centre eight pointed star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(10050),CHAR(9726))

❂

CHAR IF

Yes / No with Circled Open Centre Eight Pointed Star and White Square Button blank

Put Yes in A1 for circled open centre eight pointed star. Anything else shows white square button.

=IF(A1="Yes",CHAR(10050),UNICHAR(128275))

❂

CHAR UNICHAR IF

Yes / No with Circled Open Centre Eight Pointed Star and White Square with Rounded Corners blank

Put Yes in A1 for circled open centre eight pointed star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(10050),CHAR(9634))

❂

CHAR IF

Yes / No with Circled Open Centre Eight Pointed Star and White Circle blank

Put Yes in A1 for circled open centre eight pointed star. Anything else shows white circle.

=IF(A1="Yes",CHAR(10050),CHAR(9898))

❂

CHAR IF

Yes / No with White Medium Star and New Moon blank

Put Yes in A1 for white medium star. Anything else shows new moon.

=IF(A1="Yes",CHAR(11088),UNICHAR(127761))

⭐

CHAR UNICHAR IF

Yes / No with White Medium Star and White Large Square blank

Put Yes in A1 for white medium star. Anything else shows white large square.

=IF(A1="Yes",CHAR(11088),CHAR(11036))

⭐

CHAR IF

Yes / No with White Medium Star and White Small Square blank

Put Yes in A1 for white medium star. Anything else shows white small square.

=IF(A1="Yes",CHAR(11088),CHAR(9643))

⭐

CHAR IF

Yes / No with White Medium Star and White Medium Square blank

Put Yes in A1 for white medium star. Anything else shows white medium square.

=IF(A1="Yes",CHAR(11088),CHAR(9723))

⭐

CHAR IF

Yes / No with White Medium Star and Dotted Line Face blank

Put Yes in A1 for white medium star. Anything else shows dotted line face.

=IF(A1="Yes",CHAR(11088),UNICHAR(129509))

⭐

CHAR UNICHAR IF

Yes / No with White Medium Star and Prohibited blank

Put Yes in A1 for white medium star. Anything else shows prohibited.

=IF(A1="Yes",CHAR(11088),UNICHAR(128683))

⭐

CHAR UNICHAR IF

Yes / No with White Medium Star and Black Large Square blank

Put Yes in A1 for white medium star. Anything else shows black large square.

=IF(A1="Yes",CHAR(11088),CHAR(11035))

⭐

CHAR IF

Yes / No with White Medium Star and Black Square Button blank

Put Yes in A1 for white medium star. Anything else shows black square button.

=IF(A1="Yes",CHAR(11088),UNICHAR(128274))

⭐

CHAR UNICHAR IF

Yes / No with White Medium Star and Black Small Square blank

Put Yes in A1 for white medium star. Anything else shows black small square.

=IF(A1="Yes",CHAR(11088),CHAR(9642))

⭐

CHAR IF

Yes / No with White Medium Star and Black Medium Small Square blank

Put Yes in A1 for white medium star. Anything else shows black medium small square.

=IF(A1="Yes",CHAR(11088),CHAR(9726))

⭐

CHAR IF

Yes / No with White Medium Star and White Square Button blank

Put Yes in A1 for white medium star. Anything else shows white square button.

=IF(A1="Yes",CHAR(11088),UNICHAR(128275))

⭐

CHAR UNICHAR IF

Yes / No with White Medium Star and White Square with Rounded Corners blank

Put Yes in A1 for white medium star. Anything else shows white square with rounded corners.

=IF(A1="Yes",CHAR(11088),CHAR(9634))

⭐

CHAR IF

Yes / No with White Medium Star and White Circle blank

Put Yes in A1 for white medium star. Anything else shows white circle.

=IF(A1="Yes",CHAR(11088),CHAR(9898))

⭐

CHAR IF

Yes / No with Glowing Star and New Moon blank

Put Yes in A1 for glowing star. Anything else shows new moon.

=IF(A1="Yes",UNICHAR(127775),UNICHAR(127761))

🌟

UNICHAR IF

Yes / No with Glowing Star and White Large Square blank

Put Yes in A1 for glowing star. Anything else shows white large square.

=IF(A1="Yes",UNICHAR(127775),CHAR(11036))

🌟

UNICHAR CHAR IF

Yes / No with Glowing Star and White Small Square blank

Put Yes in A1 for glowing star. Anything else shows white small square.

=IF(A1="Yes",UNICHAR(127775),CHAR(9643))

🌟

UNICHAR CHAR IF

Yes / No with Glowing Star and White Medium Square blank

Put Yes in A1 for glowing star. Anything else shows white medium square.

=IF(A1="Yes",UNICHAR(127775),CHAR(9723))

🌟

UNICHAR CHAR IF

Yes / No with Glowing Star and Dotted Line Face blank

Put Yes in A1 for glowing star. Anything else shows dotted line face.

=IF(A1="Yes",UNICHAR(127775),UNICHAR(129509))

🌟

UNICHAR IF

Yes / No with Glowing Star and Prohibited blank

Put Yes in A1 for glowing star. Anything else shows prohibited.

=IF(A1="Yes",UNICHAR(127775),UNICHAR(128683))

🌟

UNICHAR IF

Yes / No with Glowing Star and Black Large Square blank

Put Yes in A1 for glowing star. Anything else shows black large square.

=IF(A1="Yes",UNICHAR(127775),CHAR(11035))

🌟

UNICHAR CHAR IF

Yes / No with Glowing Star and Black Square Button blank

Put Yes in A1 for glowing star. Anything else shows black square button.

=IF(A1="Yes",UNICHAR(127775),UNICHAR(128274))

🌟

UNICHAR IF

Yes / No with Glowing Star and Black Small Square blank

Put Yes in A1 for glowing star. Anything else shows black small square.

=IF(A1="Yes",UNICHAR(127775),CHAR(9642))

🌟

UNICHAR CHAR IF

Yes / No with Glowing Star and Black Medium Small Square blank

Put Yes in A1 for glowing star. Anything else shows black medium small square.

=IF(A1="Yes",UNICHAR(127775),CHAR(9726))

🌟

UNICHAR CHAR IF

Yes / No with Glowing Star and White Square Button blank

Put Yes in A1 for glowing star. Anything else shows white square button.

=IF(A1="Yes",UNICHAR(127775),UNICHAR(128275))

🌟

UNICHAR IF

Yes / No with Glowing Star and White Square with Rounded Corners blank

Put Yes in A1 for glowing star. Anything else shows white square with rounded corners.

=IF(A1="Yes",UNICHAR(127775),CHAR(9634))

🌟

UNICHAR CHAR IF

Yes / No with Glowing Star and White Circle blank

Put Yes in A1 for glowing star. Anything else shows white circle.

=IF(A1="Yes",UNICHAR(127775),CHAR(9898))

🌟

UNICHAR CHAR IF

Yes / No status lights

Put yes or no in A1. Anything else shows yellow.

=IF(LOWER(A1)="yes","🟢",IF(LOWER(A1)="no","🔴","🟡"))

🟢

IF LOWER

Approved / Not Approved thumbs

Put approved or not approved in A1. Anything else shows shrug.

=IF(LOWER(A1)="approved","👍",IF(LOWER(A1)="not approved","👎","🤷"))

👍

IF LOWER

Pass / Fail status lights

Put pass or fail in A1.

=IF(LOWER(A1)="pass","🟢",IF(LOWER(A1)="fail","🔴","🟡"))

🟢

IF LOWER

True / False status lights

Put true or false in A1.

=IF(LOWER(A1)="true","🟢",IF(LOWER(A1)="false","🔴","🟡"))

🟢

IF LOWER

On / Off status lights

Put on or off in A1.

=IF(LOWER(A1)="on","🟢",IF(LOWER(A1)="off","🔴","🟡"))

🟢

IF LOWER

Go / Stop status lights

Put go or stop in A1.

=IF(LOWER(A1)="go","🟢",IF(LOWER(A1)="stop","🔴","🟡"))

🟢

IF LOWER

Active / Inactive status lights

Put active or inactive in A1.

=IF(LOWER(A1)="active","🟢",IF(LOWER(A1)="inactive","🔴","🟡"))

🟢

IF LOWER

Done / Pending status lights

Put done or pending in A1. Other values show red.

=IF(LOWER(A1)="done","🟢",IF(LOWER(A1)="pending","🟡","🔴"))

🟢

IF LOWER

Paid / Unpaid status lights

Put paid or unpaid in A1.

=IF(LOWER(A1)="paid","🟢",IF(LOWER(A1)="unpaid","🔴","🟡"))

🟢

IF LOWER

In stock / Out of stock lights

Put in stock or out of stock in A1.

=IF(LOWER(A1)="in stock","🟢",IF(LOWER(A1)="out of stock","🔴","🟡"))

🟢

IF LOWER

Complete / Incomplete status lights

Put complete or incomplete in A1.

=IF(LOWER(A1)="complete","🟢",IF(LOWER(A1)="incomplete","🔴","🟡"))

🟢

IF LOWER

Open / Closed status lights

Put open or closed in A1.

=IF(LOWER(A1)="open","🟢",IF(LOWER(A1)="closed","🔴","🟡"))

🟢

IF LOWER

Yes / No thumbs

Put yes or no in A1. Anything else shows shrug.

=IF(LOWER(A1)="yes","👍",IF(LOWER(A1)="no","👎","🤷"))

👍

IF LOWER

Pass / Fail celebration

Put pass or fail in A1. Anything else shows thinking face.

=IF(LOWER(A1)="pass","🎉",IF(LOWER(A1)="fail","😬","🤔"))

🎉

IF LOWER

Go / Stop road signs

Put go or stop in A1. Anything else shows pause.

=IF(LOWER(A1)="go","🏁",IF(LOWER(A1)="stop","🛑","⏸️"))

🏁

IF LOWER

Active / Inactive energy

Put active or inactive in A1. Anything else shows sleeping.

=IF(LOWER(A1)="active","⚡",IF(LOWER(A1)="inactive","💤","😴"))

⚡

IF LOWER

Done / Pending clocks

Put done or pending in A1. Anything else shows hourglass.

=IF(LOWER(A1)="done","✅",IF(LOWER(A1)="pending","⏳","⌛"))

✅

IF LOWER

Paid / Unpaid money

Put paid or unpaid in A1. Anything else shows question.

=IF(LOWER(A1)="paid","💰",IF(LOWER(A1)="unpaid","💸","❓"))

💰

IF LOWER

In stock / Out of stock boxes

Put in stock or out of stock in A1. Anything else shows shrug.

=IF(LOWER(A1)="in stock","📦",IF(LOWER(A1)="out of stock","📭","🤷"))

📦

IF LOWER

Complete / Incomplete puzzle

Put complete or incomplete in A1. Anything else shows magnifier.

=IF(LOWER(A1)="complete","🧩",IF(LOWER(A1)="incomplete","🚧","🔍"))

🧩

IF LOWER

Open / Closed locks

Put open or closed in A1. Anything else shows key.

=IF(LOWER(A1)="open","🔓",IF(LOWER(A1)="closed","🔒","🔑"))

🔓

IF LOWER

True / False marks

Put true or false in A1. Anything else shows question mark.

=IF(LOWER(A1)="true","✅",IF(LOWER(A1)="false","❌","❔"))

✅

IF LOWER

On / Off power

Put on or off in A1. Anything else shows unplugged.

=IF(LOWER(A1)="on","💡",IF(LOWER(A1)="off","🌙","🔌"))

💡

IF LOWER

Win / Lose trophies

Put win or lose in A1. Anything else shows handshake.

=IF(LOWER(A1)="win","🏆",IF(LOWER(A1)="lose","😢","🤝"))

🏆

IF LOWER

Accept / Decline hands

Put accept or decline in A1. Anything else shows shrug.

=IF(LOWER(A1)="accept","🙌",IF(LOWER(A1)="decline","🙅","🤷"))

🙌

IF LOWER

Safe / Danger shields

Put safe or danger in A1. Anything else shows skull.

=IF(LOWER(A1)="safe","🛡️",IF(LOWER(A1)="danger","⚠️","☠️"))

🛡️

IF LOWER

Online / Offline signal

Put online or offline in A1. Anything else shows sync.

=IF(LOWER(A1)="online","📶",IF(LOWER(A1)="offline","📵","🔄"))

📶

IF LOWER

Like / Dislike hearts

Put like or dislike in A1. Anything else shows neutral face.

=IF(LOWER(A1)="like","❤️",IF(LOWER(A1)="dislike","💔","😐"))

❤️

IF LOWER

Ship / Hold delivery

Put ship or hold in A1. Anything else shows magnifier.

=IF(LOWER(A1)="ship","🚀",IF(LOWER(A1)="hold","⏸️","🔍"))

🚀

IF LOWER

Success / Error bursts

Put success or error in A1. Anything else shows warning.

=IF(LOWER(A1)="success","🎊",IF(LOWER(A1)="error","💥","⚠️"))

🎊

IF LOWER

Healthy / Sick wellness

Put healthy or sick in A1. Anything else shows sneeze.

=IF(LOWER(A1)="healthy","💪",IF(LOWER(A1)="sick","🤒","🤧"))

💪

IF LOWER

Up / Down votes

Put up or down in A1. Anything else shows sideways arrow.

=IF(LOWER(A1)="up","⬆️",IF(LOWER(A1)="down","⬇️","➡️"))

⬆️

IF LOWER

Ready / Not ready checklist

Put ready or not ready in A1. Anything else shows clipboard.

=IF(LOWER(A1)="ready","✅",IF(LOWER(A1)="not ready","📋","📝"))

✅

IF LOWER

Available / Busy calendar

Put available or busy in A1. Anything else shows calendar.

=IF(LOWER(A1)="available","✨",IF(LOWER(A1)="busy","🔥","📅"))

✨

IF LOWER

Yes / No with light check mark

Put Yes or No in A1.

=IF(A1="Yes",CHAR(10003)&" Yes",CHAR(10007)&" No")

✓ Yes

IF CHAR

Yes / No with heavy ballot X

Put Yes or No in A1.

=IF(A1="Yes",CHAR(10004)&" Yes",CHAR(10008)&" No")

✔ Yes

IF CHAR

Yes / No with multiplication X

Put Yes or No in A1. No uses a multiplication X.

=IF(A1="Yes",CHAR(10003)&" Yes",CHAR(10006)&" No")

✓ Yes

IF CHAR

Yes / No ballot boxes

Checked box for Yes, empty box for No.

=IF(A1="Yes",CHAR(9745)&" Yes",CHAR(9744)&" No")

☑ Yes

IF CHAR

Yes / No ballot box and X box

Checked box for Yes, X box for No.

=IF(A1="Yes",CHAR(9745)&" Yes",CHAR(9746)&" No")

☑ Yes

IF CHAR

Yes / No checkbox only

Put Yes or No in A1. Shows only the box glyph.

=IF(A1="Yes",CHAR(9745),CHAR(9744))

☑

IF CHAR

TRUE / FALSE checkbox

Put TRUE or FALSE in A1.

=IF(A1=TRUE,CHAR(9745),CHAR(9744))

☑

IF CHAR

Yes / No emoji checks

Put Yes or No in A1. Uses emoji check and X.

=IF(A1="Yes","✅ Yes","❌ No")

✅ Yes

IF

Yes / No check glyphs only

Put Yes or No in A1. No text label.

=IF(A1="Yes",CHAR(10004),CHAR(10007))

✔

IF CHAR

Yes / No case-insensitive checks

Put yes or no in A1. Any casing works.

=IF(LOWER(A1)="yes",CHAR(10004)&" Yes",CHAR(10007)&" No")

✔ Yes

IF LOWER CHAR

Done / Todo checkmarks

Put Done or Todo in A1.

=IF(LOWER(A1)="done",CHAR(10004)&" Done",CHAR(10007)&" Todo")

✔ Done

IF LOWER CHAR

Approved / Rejected checkmarks

Put Approved or Rejected in A1.

=IF(LOWER(A1)="approved",CHAR(10004)&" Approved",CHAR(10008)&" Rejected")

✔ Approved

IF LOWER CHAR

Pass / Fail checkmarks

Put Pass or Fail in A1.

=IF(LOWER(A1)="pass",CHAR(10003)&" Pass",CHAR(10007)&" Fail")

✓ Pass

IF LOWER CHAR

Complete / Incomplete checkmarks

Put Complete or Incomplete in A1.

=IF(LOWER(A1)="complete",CHAR(10004)&" Complete",CHAR(9744)&" Incomplete")

✔ Complete

IF LOWER CHAR

Checked / Unchecked with labels

Put Checked or Unchecked in A1.

=IF(LOWER(A1)="checked",CHAR(9745)&" Checked",CHAR(9744)&" Unchecked")

☑ Checked

IF LOWER CHAR

Heavy check or empty for Yes

Put Yes in A1 for a checkmark. Anything else stays blank.

=IF(A1="Yes",CHAR(10004),"")

✔

IF CHAR

Trend arrows

Put a number in A1. Positive shows up, negative down, zero flat.

=IF(A1>0,"▲ "&A1,IF(A1<0,"▼ "&A1,"→ 0"))

▲ 12

IF

Weather row

Put temperature in A1. Hot is sunny, cold is snowy.

=IF(A1>80,"☀️",IF(A1>50,"⛅",IF(A1>20,"🌧️","❄️")))

⛅

IF

Mood faces

Put mood 1-5 in A1. 1 is sad, 5 is happy.

=CHOOSE(A1,"😢","😕","😐","🙂","😄")

🙂

CHOOSE

Umbrella rain test

Put rainfall percent in A1. Over 50 shows wet.

=IF(A1>50,"☔ Wet","☀ Dry")

☔ Wet

IF

Thermometer strip

Put temperature level in A1 and scale max in B1 (e.g. 10). Shows a shaded strip plus the reading in degrees.

=REPT(CHAR(9619),MIN(A1,B1))&REPT(CHAR(9617),MAX(0,B1-A1))&" "&A1&CHAR(176)

▓▓▓▓▓░░░░░ 72°

REPT CHAR

Thermometer bulb gauge

Put temperature level in A1 and scale max in B1 (e.g. 10). Bulb emoji sits in the shaded strip.

=REPT(CHAR(9619),MIN(A1,B1))&"🌡"&REPT(CHAR(9617),MAX(0,B1-A1))&" "&A1&CHAR(176)

▓▓▓🌡░░░░░ 72°

REPT CHAR

Thermometer with leading icon

Put temperature level in A1 and scale max in B1 (e.g. 10). Thermometer icon labels the strip.

="🌡 "&REPT(CHAR(9619),MIN(A1,B1))&REPT(CHAR(9617),MAX(0,B1-A1))&" "&A1&CHAR(176)

🌡 ▓▓▓▓▓░░░░░ 72°

REPT CHAR

Fahrenheit thermometer

Put temperature level in A1 and scale max in B1 (e.g. 10). Full blocks with an F unit label.

=REPT(CHAR(9608),MIN(A1,B1))&REPT(CHAR(9617),MAX(0,B1-A1))&" "&A1&CHAR(176)&"F"

█████░░░░░ 72°F

REPT CHAR

Celsius thermometer

Put temperature level in A1 and scale max in B1 (e.g. 10). Full blocks with a C unit label.

=REPT(CHAR(9608),MIN(A1,B1))&REPT(CHAR(9617),MAX(0,B1-A1))&" "&A1&CHAR(176)&"C"

█████░░░░░ 22°C

REPT CHAR

Hot and cold thermometer

Put temperature in A1 and scale max in B1 (e.g. 10). Adds fire or snowflake when hot or cold.

=REPT(CHAR(9619),MIN(A1,B1))&REPT(CHAR(9617),MAX(0,B1-A1))&" "&A1&CHAR(176)&IF(A1>=80," 🔥",IF(A1<=32," ❄",""))

▓▓▓▓▓░░░░░ 72°

REPT CHAR IF

Vertical thermometer

Put temperature level in A1 and scale max in B1 (e.g. 10). Stacks blocks downward from a bulb. Turn on Wrap text.

="🌡"&CHAR(10)&REPT("█"&CHAR(10),MIN(A1,B1))&REPT("░"&CHAR(10),MAX(0,B1-A1))

🌡 █ █ █ █ █ ░ ░ ░ ░ ░

REPT CHAR

Oven heat thermometer

Put heat level in A1 and scale max in B1 (e.g. 10). Fire emoji marks the hot end of the strip.

=REPT("█",MIN(A1,B1))&"🔥"&REPT("░",MAX(0,B1-A1))&" "&A1&CHAR(176)

█████🔥░░░░ 450°

REPT

Freezer cold thermometer

Put cold level in A1 and scale max in B1 (e.g. 10). Snowflake marks the cold end of the strip.

="❄"&REPT("░",MAX(0,B1-A1))&REPT("▓",MIN(A1,B1))&" "&A1&CHAR(176)

❄░░░░▓▓▓▓▓ 0°

REPT

Puzzle pieces solved

Put pieces placed in A1.

=REPT("🧩",MIN(A1,B1))&REPT("□",MAX(0,B1-A1))

🧩🧩🧩□□□□□□

REPT

Rest day marker

Put rest or train in A1. Shows recovery vs training day status.

=IF(LOWER(A1)="rest","😴 Rest day","💪 Training day")

😴 Rest day

IF LOWER

Training vs rest status

Put 1 for training or 0 for rest in A1. Quick daily gym schedule flag.

=IF(A1=1,"💪 Train today","😴 Rest today")

💪 Train today

IF

Invoice paid status

Put 1 for paid or 0 for unpaid in A1. Quick invoice collection flag.

=IF(A1=1,"✅ Paid","📄 Unpaid")

✅ Paid

IF

Cash flow arrow

Put net cash in A1. Up arrow for positive flow, down for negative.

=IF(A1>=0,"📈 Cash in +$"&A1,"📉 Cash out -$"&ABS(A1))

📈 Cash in +$850

IF ABS

Tax deadline warning status

Put days until filing deadline in A1. Green, yellow, or red filing alert.

=IF(A1>30,"🟢 On track",IF(A1>7,"🟡 Due soon","🔴 File now"))

🟡 Due soon

IF

Evening wind-down status

Put wind-down step 1-4 in A1. Moon phases track your nightly shutdown.

=CHOOSE(A1,"🌆 Still working","🍵 Tea time","📵 Screens off","🌙 Asleep")

📵 Screens off

CHOOSE

Journal entry checkmark

Put 1 if journaled today or 0 if skipped. Quick daily reflection flag.

=IF(A1=1,"✅ Journaled","📝 Not yet")

✅ Journaled

IF

Pipeline stage status

Put stage 1-5 in A1. Lead, qualified, proposal, negotiation, or won.

=CHOOSE(A1,"🟡 Lead","🔵 Qualified","📋 Proposal","🤝 Negotiation","✅ Won")

📋 Proposal

CHOOSE

Follow-up overdue alert

Put days since last touch in A1. Green, yellow, or red follow-up warning.

=IF(A1<=3,"🟢 Fresh",IF(A1<=7,"🟡 Follow up","🔴 Overdue"))

🟡 Follow up

IF

Churn risk traffic light

Put churn risk 1-3 in A1. Green, yellow, or red retention alert.

=CHOOSE(A1,"🟢 Healthy","🟡 At risk","🔴 Churning")

🟡 At risk

CHOOSE

Meeting booked celebration

Put meetings booked in A1. Calendar bursts celebrate each booked slot.

=IF(A1>0,REPT("📅",MIN(A1,5))&" booked!","")

📅📅 booked!

IF REPT MIN

Lead status traffic light

Put lead status 1-3 in A1. New, engaged, or stalled pipeline flag.

=CHOOSE(A1,"🟢 New lead","🟡 Engaged","🔴 Stalled")

🟡 Engaged

CHOOSE

Demo scheduled status

Put 1 if demo booked or 0 if not. Quick demo pipeline flag.

=IF(A1=1,"✅ Demo booked","📅 No demo yet")

✅ Demo booked

IF