Sign in to follow this  
Followers 0
wes517

Setting row colors in Excel

3 posts in this topic

I've been looking for a way to set row colors in excel, and so far I haven't found it. I have done a bunch of searches in the forums, google and the help file, so if I missed it I must have been searching for the wrong information.

Basically I have 2 spreadsheets, one saying all the relevant settings on about 130 computers, and the other has an export of the results of a deployment, and I'm trying to find out what settings are causing the problem.

I want to be able to read in the list of results with computer names, and based on the success or fail, highlight that computer's row in the settings spreadsheet red or green so i can keep rerunning this periodically to see how things are going.

I have everything figured out except how to highlight the row from autoit.

Does anyone know the way to do this, or can at least point me in the right direction?

Share this post


Link to post
Share on other sites



#3 ·  Posted (edited)

Thanks for the help!

I came up with this in a function

$oExcel.Activesheet.Rows($row).Select

$oExcel.Selection.Style = $Style

from recording a macro and taking code from the excel UDF (which I'm not sure why I didn't try first...)

Edited by wes517

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  
Followers 0