Check Cell Color in VBA

Each color in Excel has its index. You can get both background and font color with a shortcode. Let’s use the following example to illustrate how the code works.

Example

Check cell background-color

In order to check the cell background color, you have to use VBA. Press Alt + F11 to open VBA Editor. Insert a new module into the project.

We will use this function to determine the background color.

code explanation

The following function checks whether the range parameter is only a single cell. If it’s not, it will display a text informing you to enter a single cell as a parameter.

If you entered a single cell, the function displays its background color.

Check cell font color

You can quickly modify this function to work also with font color.

This will give us the following result.

What you get is a color in decimal form. You may want to convert them into hexadecimal form.

If you use it for the white text you will get FFFFFF.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.

Posted in vba