However, there is no direct way in Excel to fill a range with gradient color.

But on the other hand, you need to adjust the image size, so that you can fit the cell.

Otherwise, there will be two different colors in one cell like the image show.

Before you fill the gradient color, you need to choose the two different colors for the worksheet.

Whats more, you also need to decide the RGB numbers of two colors for the gradient color.

In this example, we will use the two color: RGB(125,205,242) and RGB(215,239,228).

Besides, for different color parameters, you need to adjust the formula according to the actual numbers.

Because the color parameters are all integer, we will also round the numbers in case there exist errors.

We have zoomed out the worksheet so that you can see clearly.

In the table below, we have listed all the advantages and disadvantages of the two methods that we can think of.

When you fill a cell with another color, this color will cover the background.

And the next time you will know which method you can use in your actual worksheet.

If the environment is not safe, you cannot make sure that Excel files will always be safe.

However, even you have prepared a lot, you still have the chance to meet with Excel corruption.

Color Gradient Across Multiple Cells Excel For Mac