Re: Scripting in Excel -> search different words in column and color them
Re: Scripting in Excel -> search different words in column and color them
- Subject: Re: Scripting in Excel -> search different words in column and color them
- From: David Wignall <email@hidden>
- Date: Thu, 24 Oct 2002 22:36:23 +1300
on 24/10/2002 9:46 PM, bill at email@hidden wrote:
>
> I want to search in 5 columns the word "missing" or "FALSE" or "empty" and
>
> if it is found color it red and set the font to bold
>
>
Assume that you already know the range to search these words, this approach
>
is to compose a list of each cell name (e.g. R1C1, R1C2,...); then loop
>
through each cell and do comparison.
Just vaguely apropos to this, does AppleScript have a For Each object In
collection type of statement? The ASLG doesn't reveal anything to me.
--
Dave
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.