• Colors,  Uncategorized

    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…

  • setting background color programmatically

    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…