| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Would this require a program in EXCEL? multiple conditional statements
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statements??/Conditional formatting from drop-down multiple she | Excel Worksheet Functions | |||
| Multiple CheckBoxes can be selected require additional info if sel | Excel Worksheet Functions | |||
| Conditional formatting combined with multiple IF statements | Excel Worksheet Functions | |||
| Require a lookup to return multiple values | Excel Programming | |||
| How do I set up multiple if statements in Excel? | Excel Worksheet Functions | |||
Threaded Mode
