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
Bookmarks