• Kalpesh Agrawal

VBA Background Color

In Excel, you can change the background color of the cell by clicking just one button but in VBA you have to write the code given below to change the cell background color.

Sometimes to differ some cells from others, it is necessary to change the background color of the cell.

The method is the same as in font, just change to Interior, in place of Font.

Related: Excel VBA common basic questions
Related: How to add VBA to the Excel and common terms of VBA

Written by: Kalpesh Agrawal (Actuarial Intern- IIB)


Recent Posts

See All