Action dots

In this section, we'll explore conditional formatting with action dots. You can either create a new rule as shown here or edit the action dots inserted using the one-click option explained here.

Refer to the Create Rule section to get started. Once the rule is created and you can see the Conditional Formatting side panel, follow the steps below.

Select 'Action Dots' in the Color scale for dropdown. Format by should be set to 'Color Scale'.

Let's now look at each of the customization options.

1. Custom color ranges

You can create custom color schemes based on percentages or actual values. Click the icon to reverse the color order. Click to restore default values. Click the Add range option to add additional ranges. Use the icon to remove a particular range.

2. Single icon

You can choose to display only one dot for a range of values by selecting this option. Notice how only one action dot is rendered in the categories highlighted when the Single Icon option is enabled.

3. Hide value

Check the Hide value checkbox to see only the action dots - the values are hidden.

4. Middle percentage

The number of action dots rendered for a particular range will change based on the middle value. We've set the Middle Percentage to 70 - notice how we have more green dots and fewer red dots.