Jump to content
Sign in to follow this  
litlmike

Shading a Cell in Excel

Recommended Posts

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

IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window.

Share this post


Link to post
Share on other sites
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 by BrewManNH

If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post


Link to post
Share on other sites
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 by JLogan3o13

√-1 2^3 ∑ π, and it was delicious!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×