Trending September 2023 # Change Color Of Background Cell Using Rgb In Vba Excel # Suggested October 2023 # Top 17 Popular

You are reading the article Change Color Of Background Cell Using Rgb In Vba Excel updated in September 2023 on the website Khongconthamnam.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested October 2023 Change Color Of Background Cell Using Rgb In Vba Excel

Excel VBA RGB

VBA RGB, where RGB can be expanded by Red, Green, and Blue. And this helps in changing the color of font and cell color as well. In VBA, every color is given a value by bifurcating its shades in red, green, and blue colors. And such we have a total of 56 shades of basic colors whose RGB values range from 0 to 255.

When we apply VBA RGB, we can apply either change the color cell background or we can change the font color. Below we have the syntax of VBA RGB.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

As we can see the syntax of RGB which clearly states that for each Red, Green, and Blue, it only considers the value as Integer. And together we can count RGB values as Long data type as well. We will be seeing the implementation of the RGB in upcoming examples. Before we move ahead, let’ see one of the basic colors which we could form using RGB as shown below.

Change Color of background Cell Using RGB

We will learn how to change the color of the background cell in Excel by using the VBA Code.

You can download this VBA RGB Excel Template here – VBA RGB Excel Template

Example #1

In this example, we will see the simplest way to use RGB in VBA. Before we move forward with our Excel VBA RGB Code, first let us have data that we will be using to change the color of their cell or fonts. Below we have listed on some number from cell A1 to A10, which we will be using this example. For this, follow the below steps:

Step 2: Now in the newly opened Module write the subprocedure of VBA RGB.

Code:

Sub

VBA_RGB()

End Sub

Step 3: First we will select the cells, whose color we want to change. Here our range of cell will be from A1 to A10.

Code:

Sub

VBA_RGB() Range("A1:A10").

End Sub

Step 4: Now to change the color fonts of the selected cells, we will use the FONT function followed by COLOR.

Code:

Sub

VBA_RGB() Range("A1:A10").Font.Color

End Sub

Step 5: Now we will be using RGB with some random values to change the color Fonts from cell A1 to A10. We are giving more weightage to Red color and lesser to Green and Blue respectively as shown below.

Code:

Sub

VBA_RGB() Range("A1:A10").Font.Color = RGB(200, 100, 50)

End Sub

Example #2

In this example, we will be using the same data set which we saw in example-1 which is located in cell A1 to A10. Earlier we have seen the code to change the font colors but here we will be seeing how to change the color of a cell or background color or interior color. For this, again we can use the same line of code and do some editing or we can use a new module. We will be using the fresh module here. For this, follow the below steps:

Step 1: Open a new module and write the subprocedure for VBA RGB.

Code:

Sub

VBA_RGB2()

End Sub

Step 2: Now select the same sets of cell range from A1 to A10.

Code:

Sub

VBA_RGB2() Range("A1:A10").

End Sub

Step 3: To change the interior color, we will be using the INTERIOR function along with COLOR in the same format which we saw in Example-1.

Sub

VBA_RGB2() Range("A1:A10").Interior.Color

End Sub

Step 4: Now we will be using RGB to fill the new color to the selected cell. We will be now giving more weightage to Green color and lesser to Red and Blue colors respectively.

Code:

Sub

VBA_RGB2() Range("A1:A10").Interior.Color = RGB(0, 255, 50)

End Sub

Step 6: Let’s try to change and put the value of Green color more than 255 and see what color we get.

Code:

Sub

VBA_RGB2() Range("A1:A10").Interior.Color = RGB(0, 400, 50)

End Sub

Step 7: Now again run this updated code. We will notice that interior color selected cells A1 to A10 remains unchanged like previous, which is because RGB value resets to 255 if we use value more than 255.

Pros of VBA RGB

It is so easy to change the font color and interior color using RGB with the help of code shown in the above examples.

We can create and fill any type of color in which we want to see a font or in the cell.

Using RGB we can automate the process of changing the color of cells or fonts which is quite useful to identify the difference of data.

Things to Remember

We can try any type of combination of Red, Green, and Blue colors in RGB to see different shades of color.

We can form any type of color using RGB in Excel VBA.

The value of any color parameter can only be between o and 255. If we try to use value more than 255, it would be reset to 255 again.

Always save the file in the Macro enable format to retain the written code to be used again multiple times.