Apply color scales as conditional formats

Apply color scales as conditional formats

To apply color schemes as conditional formatting,

 

    1. Click on the Format menu.

    2. Select the Conditional Formatting option.

    3. Click on the Color Scales option from the drop down menu.

    4. In the dialogue box that appears, select the range of cells to which the conditions are to be applied.

    5. Specify the colors to be applied to each cell, based on the "Minimum", "Maximum" and the "Midpoint" criterion that you provide. These values are by default automatically calculated if you don't provide them.

    6. Hit Ok.


    • Related Articles

    • Apply color scales as conditional formats

      To apply color schemes as conditional formatting,   1. Click on the Format menu. 2. Select the Conditional Formatting option. 3. Click on the Color Scales option from the drop down menu. 4. In the dialogue box that appears, select the range of cells ...

    • Apply classic conditional formats

      To apply single-color/classic conditional formatting,   1. Click on the Format menu. 2. Select the Conditional Formatting option. 3. Click on Classic from the drop down. 4. Once the Conditional Formatting window appears, select the range of cells you ...

    • Apply a solid color, gradient, picture and pattern fill

      Fill the empty spaces inside your shapes to make them stand out on the presentation screen. Adding fills such as blended-color gradients, two-color patterns, or pictures to your slide objects not only helps your audience easily capture the ...

    • Manage Conditional Workflows

      Edit a Conditional Workflow From the Navigation toolbar, select Automation and choose Workflows. Select the conditional workflow you wish to edit. Click Manage Workflows on the top-right and select Edit.  Note: You can edit a workflow only when in ...

    • Conditional Assignment - Overview

      What is conditional assignment? Conditional Assignment solves the time-consuming problem of assigning apps individually to users, by automating the task based on preset conditions. The conditions are triggered whenever confirmed users are ...