# One-click options With Plan, you can perform various conditional formatting actions in a single click. Options include semantic formatting, color scales, segmentation, icons, ratings, data bars and many more. A big benefit of the one-click setting is that you do not need to create rules from scratch. After you create a quick rule, you will have the option to customize it in a detailed manner if your report requires it. ### 1. Quick rule Quick rule allows you to highlight the positive and negative values in the visual in a single click. Under 'Quick rule', there are two options - 'Positive' and 'Negative'.

{% hint style="info" %} The one-click conditional formatting options are enabled only if a cell/column is selected. {% endhint %} a) Select a column. You can highlight values greater than or equal to zero in green by clicking on the 'Positive' option.

b) Similarly, you can highlight values lesser than or equal to zero in red by clicking on the 'Negative' option.

### 2. Color scales A wide variety of color scales such as sequential, qualitative, diverging, continuous and continuous-diverging can be applied in a single click. a) Choose any column or cell and click on Conditional Formatting -> Color scales. Choose any of the color scales shown.

b) A sample heatmap using the sequential color scale is shown below. Notice that the font colors are automatically adjusted to be in contrast with their backgrounds for enhanced readability.

To learn more about customizing color scales, visit [this section](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/color-scale.md). ### 3. Classification You can apply conditional formatting based on icons/ratings and even deliver ABC segmentations in a single click. As you click on 'Classification', you can see the following options.

Let's look at an example for the three categories - Text, Icon set, and Rating. **3.1.** **Text**: Text-based classification is commonly used to categorize performance. A sample report with ABC classification is shown in the below image.

**3.2.** **Icons**: You can deliver conditional formatting using icons in a few clicks. Here is an example where items that contribute the most to sales are highlighted.

**3.3.** **Ratings**: You can use ratings such as the star-based ratings commonly seen in e-commerce sites in the product feedback section.

To learn more about customizing classifications, visit [this section](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/classification.md). ### 4. Data bars Data bars can be used to insert colored bars inside a cell to show how a given cell value compares to others. a) On clicking 'Data bars', you can see the following options. Select any of the options.

b) Data bars get added as shown in the image making it easy to spot the highest and lowest values at a glance.

To learn more about customizing data bars, visit [this section](https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/pages/sZZ2BIb2LTqZXiMV7252#2.-data-bars). ### 5. Action Analysis #### a) Action dot Action dots represent the degree to which the cell values deviate from the desired range/value in the measure. Adding them to the cells helps you assess how the quantities compare to the middle value or any desired value in the measure. 1. Select any measure to which you want to add them. Click **Conditional Formatting -> Action Analysis -> Action Dot.**

2. By default, Planning sheet provides custom color ranges based on values or percentages. Click **Apply.** Find below a sample report with action dots applied to the *Profit* measure.

The color scale indicates a positive or negative deviation, and the number of dots represents the magnitude of the difference, with which you can focus on the values that diverge the most. #### b) Action Color Action colors are a variation of action dots in which the degree of divergence of cell values from the target value is expressed by color gradients. The color scale denotes a positive or negative deviation, while the gradient intensity indicates the magnitude of the deviation. 1. Select any measure to which you want to add them. Click **Conditional Formatting -> Action Analysis -> Action Color.**

2. By default, Planning sheet provides custom color ranges based on values or percentages. Click **Apply.** Find below a sample report with action colors applied to the *Profit* measure.

The conditional formatting side panel provides options to customize the action dots and action colors. The options are similar to the color scale, data bars, and classification which are explained [here](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/color-scale.md#c-custom-color-scale) and [here](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings/classification.md#classification-ranges). The **middle percentage** option is used to set the desired median percentage value from which the spread is calculated. ### 6. Bubble charts You can use bubble charts to gauge the magnitude of a measure instantly and for quick comparative analysis.

The bubble size can be determined by comparing values in the same column or within the same row. You can also use a different measure to determine the size of the bubble.

You can use the side panel to customize your rules. In the next section, we'll look at the [advanced options](/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/create-rule-basic-settings.md). --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/5.-conditional-formatting/one-click-options.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.