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

learn excel macros

Excel VBA and Macros | Productivity and Automation

VBA Code to Hide Menu Ribbon in MS Access

ByKailash Sharma

VBA CODE TO HIDE MENU RIBBON IN MS ACCESS In MS Access, there are multiple ways to protect your code or tool from un-authorized access and edits. Some developers prefers to hide MS Access ribbons…

VBA Code to Check if File Exist in Folder

Productivity and Automation

VBA Code to Check if File Exist in Folder

Byexcelsirji

To ensure that your VBA project works smoothly without any error, you need to put lot of error handlers and validations. Here is one of them, below code can be used to check if the given path is valid or not. You just need to provide the path of the file to the function and it will check if the file exist at the location. If it returns True that means the file is available at the path, if it returns False that means it is invalid path or the file does not exist at the location.

VBA Tool to Merge Excel Files from a Folder

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

VBA Tool to Merge Excel Files from a Folder

Byexcelsirji

Merge Excel Files From last few months, we have been receiving frequent requests from users for a VBA tool which can consolidate Excel files from a folder. So here we come with one more free…

VBA to Read Excel Data Using Connection String

Excel VBA and Macros | Productivity and Automation

VBA code to Read Excel Data using Connection String

Byexcelsirji

VBA to Read Excel Data Using Connection String Sometimes as a programmer you need to read heavy (more then 5 MB) Excel files. There are two ways you can read data from Excel files: Open…

learn ms excel

Excel VBA and Macros | Productivity and Automation

How to Add Outlook Reference in Excel VBA

ByKailash Sharma

How to Add Outlook Reference in Excel VBA? To automate Outlook based tasks from Excel you need to add Outlook Object Library (Microsoft Outlook XX.X Object Library) in Excel References. You can follow below steps…

ColorIndex in Excel VBA

Excel VBA and Macros

How to use ColorIndex in Excel VBA – Quick Guide

Byexcelsirji

Introduction :- ColorIndex in Excel VBA Today let’s try to understand how ColorIndex property in Excel VBA works. It is an easy and effective way to quickly complete the development. ColorIndex property is normally used…

learn excel macros

Excel VBA and Macros | Productivity and Automation

VBA Code to Hide Menu Ribbon in MS Access

ByKailash Sharma

VBA CODE TO HIDE MENU RIBBON IN MS ACCESS In MS Access, there are multiple ways to protect your code or tool from un-authorized access and edits. Some developers prefers to hide MS Access ribbons…

VBA Code to Check if File Exist in Folder

Productivity and Automation

VBA Code to Check if File Exist in Folder

Byexcelsirji

To ensure that your VBA project works smoothly without any error, you need to put lot of error handlers and validations. Here is one of them, below code can be used to check if the given path is valid or not. You just need to provide the path of the file to the function and it will check if the file exist at the location. If it returns True that means the file is available at the path, if it returns False that means it is invalid path or the file does not exist at the location.

VBA Tool to Merge Excel Files from a Folder

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

VBA Tool to Merge Excel Files from a Folder

Byexcelsirji

Merge Excel Files From last few months, we have been receiving frequent requests from users for a VBA tool which can consolidate Excel files from a folder. So here we come with one more free…

VBA to Read Excel Data Using Connection String

Excel VBA and Macros | Productivity and Automation

VBA code to Read Excel Data using Connection String

Byexcelsirji

VBA to Read Excel Data Using Connection String Sometimes as a programmer you need to read heavy (more then 5 MB) Excel files. There are two ways you can read data from Excel files: Open…

learn ms excel

Excel VBA and Macros | Productivity and Automation

How to Add Outlook Reference in Excel VBA

ByKailash Sharma

How to Add Outlook Reference in Excel VBA? To automate Outlook based tasks from Excel you need to add Outlook Object Library (Microsoft Outlook XX.X Object Library) in Excel References. You can follow below steps…

ColorIndex in Excel VBA

Excel VBA and Macros

How to use ColorIndex in Excel VBA – Quick Guide

Byexcelsirji

Introduction :- ColorIndex in Excel VBA Today let’s try to understand how ColorIndex property in Excel VBA works. It is an easy and effective way to quickly complete the development. ColorIndex property is normally used…

learn excel macros

Excel VBA and Macros | Productivity and Automation

VBA Code to Hide Menu Ribbon in MS Access

ByKailash Sharma

VBA CODE TO HIDE MENU RIBBON IN MS ACCESS In MS Access, there are multiple ways to protect your code or tool from un-authorized access and edits. Some developers prefers to hide MS Access ribbons…

VBA Code to Check if File Exist in Folder

Productivity and Automation

VBA Code to Check if File Exist in Folder

Byexcelsirji

To ensure that your VBA project works smoothly without any error, you need to put lot of error handlers and validations. Here is one of them, below code can be used to check if the given path is valid or not. You just need to provide the path of the file to the function and it will check if the file exist at the location. If it returns True that means the file is available at the path, if it returns False that means it is invalid path or the file does not exist at the location.

VBA Tool to Merge Excel Files from a Folder

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

VBA Tool to Merge Excel Files from a Folder

Byexcelsirji

Merge Excel Files From last few months, we have been receiving frequent requests from users for a VBA tool which can consolidate Excel files from a folder. So here we come with one more free…

VBA to Read Excel Data Using Connection String

Excel VBA and Macros | Productivity and Automation

VBA code to Read Excel Data using Connection String

Byexcelsirji

VBA to Read Excel Data Using Connection String Sometimes as a programmer you need to read heavy (more then 5 MB) Excel files. There are two ways you can read data from Excel files: Open…

learn ms excel

Excel VBA and Macros | Productivity and Automation

How to Add Outlook Reference in Excel VBA

ByKailash Sharma

How to Add Outlook Reference in Excel VBA? To automate Outlook based tasks from Excel you need to add Outlook Object Library (Microsoft Outlook XX.X Object Library) in Excel References. You can follow below steps…

ColorIndex in Excel VBA

Excel VBA and Macros

How to use ColorIndex in Excel VBA – Quick Guide

Byexcelsirji

Introduction :- ColorIndex in Excel VBA Today let’s try to understand how ColorIndex property in Excel VBA works. It is an easy and effective way to quickly complete the development. ColorIndex property is normally used…

One Comment

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

Leave a Reply Cancel reply

Excel VBA Master Tool Kit