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

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.

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.

Dummy Data Generator Tool

Productivity and Automation

Dummy Data Generator Tool

Byexcelsirji

Dummy Data Generator is an MS Excel based tool which has capability of generating 45 types of data which includes numbers, text, date, time, Memo (long text), Boolean etc.

VBA Code to Get Computer Name

Excel VBA and Macros

VBA Code to Get Computer Name

Byexcelsirji

In this article we will learn about VBA code to get computer name. Excel VBA, or Visual Basic for Applications, is a programming language that can be used to automate tasks within the Microsoft Excel…

Write Your First Macro in Excel

Excel VBA and Macros

Write Your First Macro in Excel

Byexcelsirji

Learn how to write your first VBA macro in Excel to automate repetitive formatting tasks across multiple worksheets. This beginner-friendly guide will walk you through the process step-by-step, from recording your actions to customizing the code for your specific needs.

Outlook-Email-Management-Tool

Advanced Excel Techniques | Excel VBA and Macros

Outlook Email Management Tool

Byexcelsirji

Outlook Email Management Tool is an Excel based tool which works with Outlook 2010 or above version and helps you to read, copy or move multiple emails from an Outlook folder and sub-folders on click of a button. The tool also supports extracting attachments from emails as well.

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.

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.

Dummy Data Generator Tool

Productivity and Automation

Dummy Data Generator Tool

Byexcelsirji

Dummy Data Generator is an MS Excel based tool which has capability of generating 45 types of data which includes numbers, text, date, time, Memo (long text), Boolean etc.

VBA Code to Get Computer Name

Excel VBA and Macros

VBA Code to Get Computer Name

Byexcelsirji

In this article we will learn about VBA code to get computer name. Excel VBA, or Visual Basic for Applications, is a programming language that can be used to automate tasks within the Microsoft Excel…

Write Your First Macro in Excel

Excel VBA and Macros

Write Your First Macro in Excel

Byexcelsirji

Learn how to write your first VBA macro in Excel to automate repetitive formatting tasks across multiple worksheets. This beginner-friendly guide will walk you through the process step-by-step, from recording your actions to customizing the code for your specific needs.

Outlook-Email-Management-Tool

Advanced Excel Techniques | Excel VBA and Macros

Outlook Email Management Tool

Byexcelsirji

Outlook Email Management Tool is an Excel based tool which works with Outlook 2010 or above version and helps you to read, copy or move multiple emails from an Outlook folder and sub-folders on click of a button. The tool also supports extracting attachments from emails as well.

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.

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.

Dummy Data Generator Tool

Productivity and Automation

Dummy Data Generator Tool

Byexcelsirji

Dummy Data Generator is an MS Excel based tool which has capability of generating 45 types of data which includes numbers, text, date, time, Memo (long text), Boolean etc.

VBA Code to Get Computer Name

Excel VBA and Macros

VBA Code to Get Computer Name

Byexcelsirji

In this article we will learn about VBA code to get computer name. Excel VBA, or Visual Basic for Applications, is a programming language that can be used to automate tasks within the Microsoft Excel…

Write Your First Macro in Excel

Excel VBA and Macros

Write Your First Macro in Excel

Byexcelsirji

Learn how to write your first VBA macro in Excel to automate repetitive formatting tasks across multiple worksheets. This beginner-friendly guide will walk you through the process step-by-step, from recording your actions to customizing the code for your specific needs.

Outlook-Email-Management-Tool

Advanced Excel Techniques | Excel VBA and Macros

Outlook Email Management Tool

Byexcelsirji

Outlook Email Management Tool is an Excel based tool which works with Outlook 2010 or above version and helps you to read, copy or move multiple emails from an Outlook folder and sub-folders on click of a button. The tool also supports extracting attachments from emails as well.

One Comment

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

Leave a Reply Cancel reply

Excel VBA Master Tool Kit