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 17:09:48 +1300
on 24/10/2002 2:40 PM, Kai Edwards at email@hidden wrote:
>
on Wed, 23 Oct 2002 16:12:35 +0200, Bjorn Van Blanckenberg <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
>
>
>
> Could somebody point me in the right direction
One very small point, Bjorn: are you looking for the word "FALSE" or the
result FALSE or both, in which case this...
>
repeat with findVal in {"missing", "FALSE", "empty"}
could become
repeat with findVal in {"missing", "FALSE", "empty", false}
--
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.