What if 4.25 < x < 4.75 ?

Cheers
--
AP

"John David" a
écrit dans le message de news:
...

If there was a N-by-N array of numbers, and within the array, there were
some numbers that fell between one number and another, I want to
highlight that cell. Since there are only 4 conditional statements,
and I want to search for 10 numbers, must I write a program in EXCEL to
do this? So, for instance, I have a 32x32 array, and within the array,
I want to find numbers between 4+/-0.25, 5+/- 0.25, etc. up to 14
+/0.25. I want to color each range a different color.

For those gifted in EXCEL, must I do this with a program in EXCEL or
with conditional statements of some sort?

Thanks for your consideration.

Regards,
John


--
John David
------------------------------------------------------------------------
John David's Profile:
http://www.excelforum.com/member.php...o&userid=34609
View this thread: http://www.excelforum.com/showthread...hreadid=543830