Productivity and Automation Excel VBA and Macros

VBA Code to Change Cell Color

VBA Code To Change Cell Color

Excel supports more than 16 million colors in a cell; hence you should know how to set the exact color in a cell. To do this, you can use RGB (Red, Green, Blue) function in VBA to set the color of a cell. The function requires 3 numbers from 0 to 255 [e.g. RGB(234,232,98)]. Below is a practice code that changes cell colors to Green, Red and Blue.

Change a Cells Background Color

'This function can be used to change the color of a cell
Public Sub ChangeCellColor()

    'Change cell color to green
    Sheet1.Range("C4").Interior.Color = RGB(0, 255, 0)

    'Change cell color to red
    Sheet1.Range("C5").Interior.Color = RGB(255, 0, 0)

    'Change cell color to blue
    Sheet1.Range("C6").Interior.Color = RGB(0, 0, 255)

End Sub

VBA Code To Change Cell Color ,follow below steps:

Open an Excel file

Excel VBA Master Tool Kit

Press Alt+F11
Insert a Module (Insert>Module) from menu bar
Paste the code in the module
Now add a shape in Excel sheet
Give a name to the shape like ‘Change Cell Color’
Right click on the shape and select ‘Assign Macro…’

Select ‘ChangeCellColor’ from the list and click on ‘Ok’ button

Done, click on the shape to change the cell colors

You can also read this post to know how to get RGB Codes of a Color.

VBA Code to Count Color Cell based on Conditional Formatting

Download Practice File

You can also practice this through our practice files. Click on the below link to download the practice file.

Recommended Articles

VBA Code to Get User Name

Productivity and Automation | Excel VBA and Macros

VBA Code to Get User Name

Byexcelsirji

This Excel VBA Code helps to Get User Name. Here is an example environ(username) or Application.username.This macro gets the username from active directory.

VBA Code to Count Cells by Color

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

VBA Code to Count Cells by Color

Byexcelsirji

Have you ever felt that Microsoft should have added a formula in Excel which can count the cells based on specific color? I have seen many code requests to share a VBA code that can count the cells by its color. To help our subscribers and developers, we are sharing 2 codes that be used to count the cells with specific color and returns the count of the matching color cells.

learn excel online free

Excel VBA and Macros

VBA Code to Browse a Folder

ByKailash Sharma

VBA Code to Browse a Folder Quite often a VBA developer requires code to browse a folder. This is mainly for saving the output file or reading the input file(s). Below is the VBA code…

Employee Database Tool

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

Employee Database Tool

Byexcelsirji

Employee Database is an MS Access based tool to manage employee details. The tool supports upto 78 demographics for each employee such as Name, Location, Phone, Email, Address etc. The tool also comes with inbuilt attendance tracker to track daily attendance of employees. Over and above this, you can also design your own trackers and start using it.

VBA Code to Change Sheet Color

Excel VBA and Macros | Productivity and Automation

VBA Code to Change Sheet Color

Byexcelsirji

What is the Usage of sheet color in Excel? When we prepare a report or a dashboard it is easy to identify or analyze reports with a change of color sheet tabs. Analysts generally give…

VBA Code to Add Items in ListBox Control in Userform

Excel VBA and Macros

VBA Code to Add Items in ListBox Control in Userform

Byexcelsirji

VBA Code To Add Items In Listbox Control Using ListBox in Userform is very common. You can use ListBox.AddItem function to add items in the listbox.; however, it is little difficult to add items in…

VBA Code to Get User Name

Productivity and Automation | Excel VBA and Macros

VBA Code to Get User Name

Byexcelsirji

This Excel VBA Code helps to Get User Name. Here is an example environ(username) or Application.username.This macro gets the username from active directory.

VBA Code to Count Cells by Color

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

VBA Code to Count Cells by Color

Byexcelsirji

Have you ever felt that Microsoft should have added a formula in Excel which can count the cells based on specific color? I have seen many code requests to share a VBA code that can count the cells by its color. To help our subscribers and developers, we are sharing 2 codes that be used to count the cells with specific color and returns the count of the matching color cells.

learn excel online free

Excel VBA and Macros

VBA Code to Browse a Folder

ByKailash Sharma

VBA Code to Browse a Folder Quite often a VBA developer requires code to browse a folder. This is mainly for saving the output file or reading the input file(s). Below is the VBA code…

Employee Database Tool

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

Employee Database Tool

Byexcelsirji

Employee Database is an MS Access based tool to manage employee details. The tool supports upto 78 demographics for each employee such as Name, Location, Phone, Email, Address etc. The tool also comes with inbuilt attendance tracker to track daily attendance of employees. Over and above this, you can also design your own trackers and start using it.

VBA Code to Change Sheet Color

Excel VBA and Macros | Productivity and Automation

VBA Code to Change Sheet Color

Byexcelsirji

What is the Usage of sheet color in Excel? When we prepare a report or a dashboard it is easy to identify or analyze reports with a change of color sheet tabs. Analysts generally give…

VBA Code to Add Items in ListBox Control in Userform

Excel VBA and Macros

VBA Code to Add Items in ListBox Control in Userform

Byexcelsirji

VBA Code To Add Items In Listbox Control Using ListBox in Userform is very common. You can use ListBox.AddItem function to add items in the listbox.; however, it is little difficult to add items in…

VBA Code to Get User Name

Productivity and Automation | Excel VBA and Macros

VBA Code to Get User Name

Byexcelsirji

This Excel VBA Code helps to Get User Name. Here is an example environ(username) or Application.username.This macro gets the username from active directory.

VBA Code to Count Cells by Color

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

VBA Code to Count Cells by Color

Byexcelsirji

Have you ever felt that Microsoft should have added a formula in Excel which can count the cells based on specific color? I have seen many code requests to share a VBA code that can count the cells by its color. To help our subscribers and developers, we are sharing 2 codes that be used to count the cells with specific color and returns the count of the matching color cells.

learn excel online free

Excel VBA and Macros

VBA Code to Browse a Folder

ByKailash Sharma

VBA Code to Browse a Folder Quite often a VBA developer requires code to browse a folder. This is mainly for saving the output file or reading the input file(s). Below is the VBA code…

Employee Database Tool

Advanced Excel Techniques | Excel VBA and Macros | Productivity and Automation

Employee Database Tool

Byexcelsirji

Employee Database is an MS Access based tool to manage employee details. The tool supports upto 78 demographics for each employee such as Name, Location, Phone, Email, Address etc. The tool also comes with inbuilt attendance tracker to track daily attendance of employees. Over and above this, you can also design your own trackers and start using it.

VBA Code to Change Sheet Color

Excel VBA and Macros | Productivity and Automation

VBA Code to Change Sheet Color

Byexcelsirji

What is the Usage of sheet color in Excel? When we prepare a report or a dashboard it is easy to identify or analyze reports with a change of color sheet tabs. Analysts generally give…

VBA Code to Add Items in ListBox Control in Userform

Excel VBA and Macros

VBA Code to Add Items in ListBox Control in Userform

Byexcelsirji

VBA Code To Add Items In Listbox Control Using ListBox in Userform is very common. You can use ListBox.AddItem function to add items in the listbox.; however, it is little difficult to add items in…

One Comment

Pingback: ExcelSirJi | FREE COURSE | Chapter 6 – Excel Object Model

Leave a Reply Cancel reply

Excel VBA Master Tool Kit