Shading a Cell in Excel

[litlmike]

Anyone know how to shade a cell in Excel?

I have been trying variations of this:

$oWorkbook.Activesheet.Range('A1:G1').Select.Interior.TintAndShade = 0.799981688894314

[jdelaney]

http://office.microsoft.com/en-us/excel-help/change-cell-background-color-using-vba-HA001136627.aspx

I'll leave it to you to look up the color indexes:

$oExcel = _ExcelBookNew(1)
_ExcelSheetActivate($oExcel,1)
$oExcel.Activesheet.Range('A1:G1').Interior.ColorIndex = 5

[BrewManNH]

Here's one way of doing it.

' select the top row A through J
objExcel.Range("A1:J1").Select 
' Set the background color to index #4 (light green)
objExcel.Selection.Interior.ColorIndex = 4 
' set solid background color pattern
objExcel.Selection.Interior.Pattern = 1
' set the text color to index #1 (black)
objExcel.Selection.Font.ColorIndex = 1

This is a VBScript which is easy to convert to AutoIt.

EDIT: BTW, the index colors are here http://dmcritchie.mvps.org/excel/colors.htm

Edited September 3, 2014 by BrewManNH

[JLogan3o13]

@OP, if you did truly mean TintAndShade, I have never seen it done on a cell; I usually use it only if I am drawing a shape of some sort.

http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.interior.tintandshade(v=office.15).aspx

Edited September 3, 2014 by JLogan3o13