Example - Add Emojis to Hightlight Values

This example shows how to use emojis in conditional formatting to highlight values.

In this example you highlight products types such as audio, phones, and accessories with an emoji where the revenue is greater than 700,000, in addition to stoplight formatting.

Description of the illustration emoji_ex3.png

Here's how to configure this example using the Conditional Formatting dialog.

• Create a rule and click the 3 Steps Threshold in Presets.
• Select REVENUE as the measure and configure the thresholds as greater than 700,000, between 200,000 and 700,000, and less than 200,000.
• Click Format for the greater than 700,000 threshold.
  
  
  Description of the illustration emoji_ex1.png
  
  
• Click Icon, then click Emoji, and select a smile emoji.
  
  
  Description of the illustration emoji_ex2.png