Example - Hightlight Values with Emojis
This example shows how to use emojis in conditional formatting to highlight values.
In this example you highlight product types such as audio, phones, and accessories with an emoji where the revenue is greater than 700,000, in addition to stoplight formatting.
Here's how to configure this example using the Conditional Formatting dialog.
- Create a rule and click the 3 Steps Threshold in Presets.
- In the Column field, select REVENUE 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.
- Click Icon, then click Emoji, and select a smile emoji.
