Re: Conditional Format Formula Length Issue?

Giganews Newsgroups
Subject: Re: Conditional Format Formula Length Issue?
Posted by:  J.E. McGimpsey (jemcgimps…@mvps.org)
Date: Wed, 08 Oct 2003

One way:

CF1:    =SUMPRODUCT(--($E$9:$T$9<=AL5),--($E$11:$T$11>=AL5))

In article <020601c38dc0$82041a10$a30128…@phx.gbl>,
"Ken" <Kenneth.H.All…@pw.utc.com> wrote:

> I have the following formula in Conditional Formatting
> under "Formula is" ... Issue is ... I haven't finished
> writing it & I am out of characters ... :(
>
> Basically, I need the "AND" part of the following formula
> 16 times  ... =OR(AND(AL5>=$E$9,AL5<=$E$11),AND(etc etc
>
> E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T = 16
>
> Thanks ... Kha

Replies

In response to

Conditional Format Formula Length Issue? posted by Ken on Wed, 8 Oct 2003