Author Introduction:Īnna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair Word doc document corruption and outlook repair software products. Once your Excel corrupts, you can use this tool to repair corrupt xlsx data immediately. Therefore, you can prepare a third-party beforehand. However, even you have prepared a lot, you still have the chance to meet with Excel corruption. If the environment is not safe, you cannot make sure that Excel files will always be safe. The environment is also very important for your Excel files. Keep a Safe Environment for Your Excel Files And the next time you will know which method you can use in your actual worksheet. Now you have a deeper understand of the two methods. If you use VBA to fill a small range, the color transition will be not so natural. You still need to modify the codes for other ranges if you have needs.ģ. Only a target range will be filled with gradient color. When you need to modify the codes, you will easily make mistakes.Ģ. When you fill a cell with another color, this color will cover the background.ġ. In the border of the size of the background, there will be obvious boundaries.ģ. You need to spend time to find an image or make an image with gradient color.Ģ. This method will not produce unsuitable borders with two different colors.ġ. Just by one click or one press, you can get the result immediately.Ģ. The whole worksheet will be filled with the gradient color by this method.ġ. If you are not familiar with Excel VBA, this method is your choice.Ģ. In the table below, we have listed all the advantages and disadvantages of the two methods that we can think of.ġ. But sometimes you will not know which method you can use. You can see that both methods are very effective. When you need to fill other range with gradient color, you need to modify the codes and run it again. The target range is filled with gradient color. We have zoomed out the worksheet so that you can see clearly.
In this example, we will fill the range A1:E100. Range("A" & nTargetRowCount, "E" & nTargetRowCount).Interior.Color = RGB( _ After that, copy the following codes into the module:.Thus, you can open the Visual Basic editor.
Press the button “Alt +F11” on the keyboard.What’s more, you also need to decide the RGB numbers of two colors for the gradient color. Before you fill the gradient color, you need to choose the two different colors for the worksheet. And you will need to use Excel VBA to finish this task. This is actually the border of the background image. Otherwise, there will be two different colors in one cell like the image show. But on the other hand, you need to adjust the image size, so that you can fit the cell. Thus, the image has become the background of this worksheet. And then click the button “Insert” in the window.After that, choose the path that contains the target image.And then click the button “Background” in the toolbar.In the worksheet, click the tab “Page Layout” in the ribbon.Now open the target Excel that you need to fill gradient color.Or you can also make such an image in your computer. Find an image with the gradient color that you like.In this method, you can insert an image with gradient color as the background. Now we have found two methods to finish this task. However, there is no direct way in Excel to fill a range with gradient color. Besides, you can also fill gradient color in a cell. It is very easy for you to fill a cell or a range with a certain color. In this article, we will introduce two methods to fill your worksheet with gradient color. If you can use gradient color in your work, you are sure to improve your work efficiency.
0 kommentar(er)
