Category Archives: Color

No Thumbnail

Excel VBA, Fill Pattern

Various different patterns can be applied to cells in Excel. These patterns can be applied manually using the Format Cell dialog: This article will explain how you can apply different patterns to cells using VBA for Excel. Jump To: Basics Example 1, Set Pattern Example

No Thumbnail

Excel VBA, Column Gradient Color

In the article Excel VBA, Gradient’s Colors I’ve explained the basics about working with gradient’s color. I’m assuming the reader is familiar with the topics covered in that article. – Gradient Color, Column: In the article Excel VBA, Gradient’s Colors I provided 2 examples for creating gradients with different colors. The examples

No Thumbnail

Excel VBA, Range Fill Color

The following lines all changes the fill color of the range “A1:B1” to blue: Range(“A1:B2”).Interior.Color = vbBlue Same as the previous line but using a different notation: Range(Cells(1, 1), Cells(2, 2)).Interior.Color = vbBlue Same as the previous lines but instead of using the blue color constant

No Thumbnail

Excel VBA, Column Fill Color

The following line changes the fill color of the first column to blue: Columns(1).Interior.Color = vbBlue Same as the previous line but instead of using the blue color constant it uses the blue color code Columns(1).Interior.Color = 16711680 For more information about working with colors in

No Thumbnail

Excel VBA, Gradient’s Colors

This article explains how you can change a gradient’s first and second color using VBA for Excel. It also provides a sample for getting the current gradient color used in a cell. Note the codes in this article assume a gradient already exists and we are

No Thumbnail

Excel VBA, Font Color

In this article I will explain how you can change the font color of cells and ranges in Excel using VBA. I’ve also provided an example on how you can get the current font color used in a cell. For more information about working with

No Thumbnail

Excel VBA, Color Code

This article provides a sample on using the color code in VBA for Excel. In this example the user inputs a color code in cell B1. The fill color in cell A1 is changed to the color defined by the color code in cell B1.

No Thumbnail

VBA Excel, Colors

This article explain how you can work with colors in VBA for Excel. When working with Excel there are many cases when you will need to specify a color: When selecting a fill color When changing the font color When changing the border color … To

No Thumbnail

Excel VBA Border Colors

One of the things you probably want to modify when working with borders in VBA for Excel is the border color. Previously I’ve explained about colors in the article VBA Excel Colors. Therefore I’m assuming readers are familiar with the basic concept of working with

No Thumbnail

Excel VBA, Row Fill Color

The following line changes the fill color of the first row to blue: Rows(1).Interior.Color = vbBlue Same as the previous line but instead of using the blue color constant it uses the blue color code Rows(1).Interior.Color = 16711680 For more information about working with colors in