How to change Background Color of Cell Range

[mikhail_a]

I am a Delphi developer.
My application has a function to import data into Excel.
I want to add a data import function to PlanMaker.
I have successfully implemented this feature but I have not found a way to change the cell color.
For example, the code "Sheet.Range ['A1: C1']. Font.BColorIndex: = 15;" changes the background of the text successfully.
However, the code "Sheet.Range ['A1: C1']. BColorIndex: = 15;" is wrong.
How do I change the color of a cell?

[SuperTech]

Please try this code

Code: Select all

Sheet.Range("A1:C1").Shading.ForegroundPatternColorIndex = 15