The line you should use when you need to set a new background color to a cell is: Sheets(“Sheet1”).Range(“C3”).Interior.Color = RGB(255, 255, 0) The color will be yellow. For other colors please see the color map article.
Using colors in excel and VBA is very simple. The most used function is RGB(x, y, z). Where x is the variable for red color, y is for green and z is for blue. All variables can have values from 0 to 255, where 0 is no color and 255 is the maximum level for […]