Set cell background color programmatically
The VBA code 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) RGB(255, 255, 0) = Yellow (full Red and full Green) Where RGB defines the color you need as a mix of 3 color:Red Green and Blue (RGB). Zero means no […]
RGB color map
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 […]