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

Outlook-Bulk-Email-Tool

Productivity and Automation

Outlook Bulk Email Tool

Byexcelsirji

Outlook Bulk Email Tool is an Excel and Outlook based tool which helps you to send or draft email in bulk right from Excel. It reads the recipient details from Excel sheet and uses Outlook installed on your system to generate emails. The tool supports To, Cc, Subject, Email Body, Attachment, HTML Table in Email Body.

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 read outlook emails

Excel VBA and Macros

VBA Code to Read Outlook Emails

ByKailash Sharma

VBA Code to Read Outlook Emails Reading emails from Outlook and capture them in Excel file is very common activity being performed in office environment. Doing this activity manually every time is quite boring and…

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 Re-link MS Access Link Tables

Productivity and Automation

VBA Code to Re-link MS Access Link Tables

Byexcelsirji

In MS Access, the best way to create a multiuser tool is to divide your solution. One part acts as interface and other one acts as database. You can have multiple copies of the interface distributed to users which are connected to central MS Access database saved at common shared drive. To connect the interface to database, you can use link table feature (Access>External Data>Import & Link) available in MS Access. Below is a commonly required VBA code which helps the developers to re-link MS Access linked tables when the database is renamed or moved to other location

Excel Files and Sheets Consolidator

Productivity and Automation

Excel Files and Sheets Data Consolidation

Byexcelsirji

Excel Files and Sheets Consolidator is an MS Excel based data consolidation tool which can be used to consolidate data from multiple Excel Files or Excel Sheets. The tool supports multiple configurations such as Sheet Name, Sheet Index, Header Row and Non-Blank column to help consolidating accurate data.

Outlook-Bulk-Email-Tool

Productivity and Automation

Outlook Bulk Email Tool

Byexcelsirji

Outlook Bulk Email Tool is an Excel and Outlook based tool which helps you to send or draft email in bulk right from Excel. It reads the recipient details from Excel sheet and uses Outlook installed on your system to generate emails. The tool supports To, Cc, Subject, Email Body, Attachment, HTML Table in Email Body.

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 read outlook emails

Excel VBA and Macros

VBA Code to Read Outlook Emails

ByKailash Sharma

VBA Code to Read Outlook Emails Reading emails from Outlook and capture them in Excel file is very common activity being performed in office environment. Doing this activity manually every time is quite boring and…

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 Re-link MS Access Link Tables

Productivity and Automation

VBA Code to Re-link MS Access Link Tables

Byexcelsirji

In MS Access, the best way to create a multiuser tool is to divide your solution. One part acts as interface and other one acts as database. You can have multiple copies of the interface distributed to users which are connected to central MS Access database saved at common shared drive. To connect the interface to database, you can use link table feature (Access>External Data>Import & Link) available in MS Access. Below is a commonly required VBA code which helps the developers to re-link MS Access linked tables when the database is renamed or moved to other location

Excel Files and Sheets Consolidator

Productivity and Automation

Excel Files and Sheets Data Consolidation

Byexcelsirji

Excel Files and Sheets Consolidator is an MS Excel based data consolidation tool which can be used to consolidate data from multiple Excel Files or Excel Sheets. The tool supports multiple configurations such as Sheet Name, Sheet Index, Header Row and Non-Blank column to help consolidating accurate data.

Outlook-Bulk-Email-Tool

Productivity and Automation

Outlook Bulk Email Tool

Byexcelsirji

Outlook Bulk Email Tool is an Excel and Outlook based tool which helps you to send or draft email in bulk right from Excel. It reads the recipient details from Excel sheet and uses Outlook installed on your system to generate emails. The tool supports To, Cc, Subject, Email Body, Attachment, HTML Table in Email Body.

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 read outlook emails

Excel VBA and Macros

VBA Code to Read Outlook Emails

ByKailash Sharma

VBA Code to Read Outlook Emails Reading emails from Outlook and capture them in Excel file is very common activity being performed in office environment. Doing this activity manually every time is quite boring and…

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 Re-link MS Access Link Tables

Productivity and Automation

VBA Code to Re-link MS Access Link Tables

Byexcelsirji

In MS Access, the best way to create a multiuser tool is to divide your solution. One part acts as interface and other one acts as database. You can have multiple copies of the interface distributed to users which are connected to central MS Access database saved at common shared drive. To connect the interface to database, you can use link table feature (Access>External Data>Import & Link) available in MS Access. Below is a commonly required VBA code which helps the developers to re-link MS Access linked tables when the database is renamed or moved to other location

Excel Files and Sheets Consolidator

Productivity and Automation

Excel Files and Sheets Data Consolidation

Byexcelsirji

Excel Files and Sheets Consolidator is an MS Excel based data consolidation tool which can be used to consolidate data from multiple Excel Files or Excel Sheets. The tool supports multiple configurations such as Sheet Name, Sheet Index, Header Row and Non-Blank column to help consolidating accurate data.

One Comment

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

Leave a Reply Cancel reply

Excel VBA Master Tool Kit