Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.scripting.vbscript > #12472
| X-Received | by 2002:a05:620a:20dc:b0:71f:b89c:69b0 with SMTP id f28-20020a05620a20dc00b0071fb89c69b0mr288015qka.0.1676672935759; Fri, 17 Feb 2023 14:28:55 -0800 (PST) |
|---|---|
| X-Received | by 2002:a81:ae68:0:b0:52e:cacb:d7c4 with SMTP id g40-20020a81ae68000000b0052ecacbd7c4mr271971ywk.5.1676672935432; Fri, 17 Feb 2023 14:28:55 -0800 (PST) |
| Path | csiph.com!tncsrv06.tnetconsulting.net!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail |
| Newsgroups | microsoft.public.scripting.vbscript |
| Date | Fri, 17 Feb 2023 14:28:55 -0800 (PST) |
| In-Reply-To | <C2D4C350.4261%Gill.Gilliland@UnitedWater.com> |
| Injection-Info | google-groups.googlegroups.com; posting-host=93.51.27.132; posting-account=7ZuDrQoAAABePZkipgAPTS25veuj4_ue |
| NNTP-Posting-Host | 93.51.27.132 |
| References | <AcfTgXRfssC1rT90EdyhsgAX8sNJqQ==> <C2D4C350.4261%Gill.Gilliland@UnitedWater.com> |
| User-Agent | G2/1.0 |
| MIME-Version | 1.0 |
| Message-ID | <5a13ae9f-1dee-4d54-8732-e6c31a8c4881n@googlegroups.com> (permalink) |
| Subject | Re: Adding a conditional format to an excel report via vbscript |
| From | angelo tavola <angelotavo69@gmail.com> |
| Injection-Date | Fri, 17 Feb 2023 22:28:55 +0000 |
| Content-Type | text/plain; charset="UTF-8" |
| Content-Transfer-Encoding | quoted-printable |
| X-Received-Bytes | 1833 |
| Xref | csiph.com microsoft.public.scripting.vbscript:12472 |
Show key headers only | View raw
Il giorno martedì 31 luglio 2007 alle 16:45:36 UTC+2 Gilliland, Gill ha scritto: > I've found plenty of references to add a conditional format to an excel > sheet using VBA, but I cannot figure out how to translate that to vbscript. > The following is a VBA example that would alternate row colors. I would like > to set this formatcondition using vbscript: > Selection.FormatConditions.Delete > Selection.FormatConditions.Add Type:=xlExpression, _ > Formula1:="=MOD(ROW(),2)=1" > Selection.FormatConditions(1).Interior.ColorIndex = 15 > Thanks for any help, > Gill
Back to microsoft.public.scripting.vbscript | Previous | Next | Find similar
Re: Adding a conditional format to an excel report via vbscript angelo tavola <angelotavo69@gmail.com> - 2023-02-17 14:28 -0800
csiph-web