Excel Row Format - microsoft.public.windows.powershell

Message from discussion Excel Row Format

dlisterjr

View profile

More options Apr 1, 3:48 pm

Newsgroups: microsoft.public.windows.powershell

From: dlisterjr <dliste...@discussions.microsoft.com>

Date: Tue, 1 Apr 2008 12:48:02 -0700

Local: Tues, Apr 1 2008 3:48 pm

Subject: Re: Excel Row Format

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

The problem is that I need to search each row for data and then format that
row base on if the data exist. The macro really didn't help with that.

"Oisin (x0n) Grehan [MVP]" wrote:

> On Apr 1, 10:27 am, dlisterjr <dliste...@discussions.microsoft.com>
> wrote:
> > Is there a way to search a spreadsheet and then change the font color of the
> > row if the cell contains a string? IE if a cell in the row contains the word
> > "closed" (it won't be the only word in the cell), I want the whole row font
> > color red.

> Hi,

> Yes, this should be possible in PowerShell - I don't have the facility
> to test it here, but when usually when I need to do something like
> this, I record a macro in Excel of the actions I want to automate,
> then I view the VBA code in the editor IDE and translate/adapt it to
> powershell. You'll need an entry point into the Excel object model,
> which starts with:

> $excel = new-object -com excel.application

> ..and should end with:

> $excel.Quit()

> If you're still stuck on this later, drop a note back here and I'll
> help you finish it off.

> - Oisin

Reply to author Forward