How To Add Gradient Fill In Excel

We run into colour scales representing all sorts of things: temperatures, speed, ages, and fifty-fifty population. If you take data in Microsoft Excel that could benefit from this type of visual, it'due south easier to implement than you might recall.

With conditional formatting, you can utilise a slope color scale in just minutes. Excel offers 2- and 3-color scales with primary colors that yous can select from, along with the option to selection your own unique colors.

Utilise a Quick Conditional Formatting Color Scale

Microsoft Excel provides you with several conditional formatting rules for color scales that you lot tin apply with a quick click. These include vi two-color scales and half dozen three-colour scales.

Select the cells that yous want to apply the formatting to by clicking and dragging through them. Then, caput to the Styles department of the ribbon on the Home tab.

Click "Conditional Formatting" and motion your cursor to "Color Scales." You'll see all 12 options in the pop-out carte.

As you lot hover your cursor over each one, you can see the organisation of the colors in a screen tip. Plus, you'll see the cells that yous've selected highlighted with each pick. This gives you a terrific mode to select the color scale that best fits your data.

When you land on the calibration that you want to utilize, just click it. And that's all in that location is to it! Yous've only applied a color scale to your data in a few clicks.

Create a Custom Conditional Formatting Colour Calibration

If one of the quick rules above doesn't quite capture how y'all want your colour scale to work, you tin can create a custom conditional formatting rule.

Select the cells that you want to apply the scale to, go to the Domicile tab, and choose "New Rule" from the Conditional Formatting drop-downward list.

When the New Formatting Rule window opens, select "Format All Cells Based on Their Values" at the top.

The Edit the Rule Description section at the bottom of the window is where you'll spend a bit of time customizing the rule. First by choosing two-Color Scale or 3-Color Scale from the Format Style drop-downwardly listing.

The main difference between these two styles is that the three-color calibration has a midpoint, whereas the 2-color scale merely has minimum and maximum values.

Afterward selecting the color scale style, cull the Minimum, Maximum, and optionally, the Midpoint using the Types drop-down lists. You tin can selection from Lowest/Highest Value, Number, Percent, Formula, or Percentile.

The Lowest Value and Highest Value types are based on the information in your selected range of cells, so you don't have to enter annihilation in the Value boxes. For all other types, including Midpoint, enter the Values in the respective boxes.

Finally, click the Color drib-down buttons to select your colors from the palettes. If you want to use custom colors, select "More than Colors" to add them using RGB values or Hex codes.

Yous'll then run across a preview of your colour scale at the bottom of the window. If yous're happy with the result, click "OK" to apply the conditional formatting to your cells.

The nice thing about a conditional formatting rule like this is that if you edit your data, the color scale will automatically update to accommodate the alter.

For a similar mode to display your Excel data, consider using the Data Bars conditional formatting dominion to create a progress bar.

Source: https://www.howtogeek.com/734938/how-to-apply-a-color-scale-based-on-values-in-microsoft-excel/

Share this post