Excel does not have a general-purpose command that physically blends cell colors. Choose the method by the result you want: apply a fixed fill to cells, shade cells according to their values with a color scale, or add a gradient to a shape.
Which Excel color method should you use?
| What you want | Use | How the color is chosen |
|---|---|---|
| The same color in one or more cells | Fill Color or More Colors | You choose a fixed color; it does not blend with neighboring cell fills. Microsoft Support |
| Shading that varies across data | Conditional Formatting > Color Scales | Each cell’s value is mapped to colors according to the scale’s thresholds. Microsoft Support |
| A gradient across a visual object | Shape Fill > Gradient | Color changes across the shape between gradient stops. Microsoft Support |
| A two-color texture in cells | Format Cells > Fill | You select a background color, pattern color, and pattern style. Pattern fill effects do not appear in Excel for the web. Microsoft Support |
How to apply a fixed or custom cell color
- Select the cell or range you want to format.
- Open Home > Fill Color using the arrow beside the paint-bucket icon.
- Choose a Theme Color or Standard Color. For a custom shade, choose More Colors and select a color in the dialog.
- To remove the fill later, select the cells and choose No Fill from the Fill Color menu.
Excel saves up to 10 recently selected custom colors for reuse. A fixed fill remains the color you selected; it is not blended with the fill in an adjacent cell. Microsoft Support
As an Amazon Associate I earn from qualifying purchases.
How to create a color scale based on cell values
A color scale is the closest Excel equivalent to a color blend across a data range: the cells receive different shades based on their values. It is conditional formatting, not a set of permanent, independent fills. Microsoft describes color scales as visual guides for understanding data distribution and variation. Microsoft Support
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →- Select the range containing the values.
- Choose Home > Conditional Formatting > Color Scales.
- Select a two-color scale for a low-to-high transition or a three-color scale for low, middle, and high values.
- If the default mapping does not fit your data, open Home > Conditional Formatting > Manage Rules, edit the rule, and set the minimum and maximum; for a three-color scale, set the midpoint as well.
- For each scale point, choose a color and set its threshold type or value. Available threshold choices include numbers, percentages, percentiles, and formula results.
Because the colors depend on the rule and the range’s values, changing the data can change the displayed shading. Use this when you want to see relative variation, rather than to assign a lasting color to each cell regardless of its value. Microsoft Support
#1 Best Overall
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
How to add a gradient to a shape
For a smooth color transition across a graphic, insert or select a shape, then choose Shape Fill > Gradient. To customize the transition, adjust its gradient stops—the points where adjacent colors in the gradient end. This workflow applies to shapes; it is not a general gradient-fill command for worksheet cells. Microsoft Support
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.How to make patterned fills or alternating rows
Apply a two-color pattern
In desktop Excel, open the Format Cells dialog and select the Fill tab. Choose a background color, a pattern color, and a pattern style. Pattern fill effects created in desktop Excel do not display in Excel for the web. Microsoft Support
Shade alternate rows or columns
Use a formula-based conditional-formatting rule to band a range. Select the target range, create a new rule that uses a formula, enter =MOD(ROW(),2)=0, then choose Format > Fill and select a color. To shade alternate columns instead, use =MOD(COLUMN(),2)=0. Microsoft Support
Quick Recap
Best Value
What to check if a fill is not visible or printable
- If a cell looks uncolored, check whether its setting is No Fill, whether you selected the intended theme or custom color, and whether high-contrast display mode is affecting the colors on screen. Microsoft Support
- If shading is missing on a printout, check the worksheet’s Page Setup print options. Black-and-white or draft-quality printing can prevent cell shading from printing in color. Microsoft Support
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
