Conditional Format Formula Length Issue?

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

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
 
J.E. ...

Beautiful ... I do not know how it works, but that's ok
because it works. I simply do not know how one gets so
intimate with Excel ... but I am certainly glad you do.

Now one more formula to shorten ... Maybe? ... Please if
possible ... it is working, but shorter would be better.

=OR
(BG5=$E$10,BG5=$F$10,BG5=$G$10,BG5=$H$10,BG5=$I$10,BG5=$J$1
0,BG5=$K$10,BG5=$L$10,BG5=$M$10,BG5=$N$10,BG5=$O$10,BG5=$P$
10,BG5=$Q$10,BG5=$R$10)

Thanks again for supporting & responding to this board ...
Kha
 
J.E.

Yes ... formula working fine ... Initially, I entered
formula with no space ... I never saw a space in formula
before & simply thought it was a typo ... Woke up in
middle of night thinking about this ... Came in this
morning & entered space to formula & ... Magic ... Working
like a charm ... Thanks ... Kha
 
Back
Top