<< Click to Display Table of Contents >> Navigation:  Macros > Macro commands and parameters > Macro reporting commands > Macro write to Excel > Macro command Backcolor

Purpose:

To colour the background of a range of cells in a spreadsheet.

 

General notation:

Backcolor ( FileIndex, sheet, row1, column1, row2, column2, colour )

 

Series of cells can be addressed using row and column numbers. The values row1 and column1 refer to the top left-hand corner of a series, while row2 and column2 refer to the bottom right-hand corner. The normal Excel notation (identification of a cell by means of a combination of letters and numbers) is not possible because the macro language works on a numeric basis.

 

All parameters are integer values. Colour is an integer value between 0 and 14, representing the colours: black, gray, lightgray, navy, blue, aqua, purple, fuchsia, green, lime, teal, maroon, red, yellow and white.