Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automate grading of performance test results
Using imbeded worksheet to calculate H dif. and L dif. for testing up to 10
units. in this example the 2nd, 3rd and 5th units fail because H dif. is grater than 3. Max L dif. is 1. Is there some way for Excel to determine the failed units and indicate them? (In order to paste a sample, I had to hide most of the columns) Date 05/28/03 #1 Safety Tach Production V2.1 Prep: Up to 10 units tested on elevator floor. Includes 1st run. 10 units tested. 60 Second warm up time. # 503-19 P00001 up HI LV HI LV H dif. L dif. 1 164 9 168 10 4 1 2 165 9 167 10 3 1 3 166 9 168 10 4 1 4 165 9 167 10 4 1 5 164 9 167 10 4 1 2 0 1 0 2 0 2 1 -- Thanks, Kirk |
#2
|
|||
|
|||
On Tue, 24 May 2005 13:00:03 -0700, rkm wrote:
Using imbeded worksheet to calculate H dif. and L dif. for testing up to 10 units. in this example the 2nd, 3rd and 5th units fail because H dif. is grater than 3. Max L dif. is 1. Is there some way for Excel to determine the failed units and indicate them? (In order to paste a sample, I had to hide most of the columns) Date 05/28/03 #1 Safety Tach Production V2.1 Prep: Up to 10 units tested on elevator floor. Includes 1st run. 10 units tested. 60 Second warm up time. # 503-19 P00001 up HI LV HI LV H dif. L dif. 1 164 9 168 10 4 1 2 165 9 167 10 3 1 3 166 9 168 10 4 1 4 165 9 167 10 4 1 5 164 9 167 10 4 1 2 0 1 0 2 0 2 1 Take a look at Conditional Formatting (on the Format Sub Menu) You can format an entire range at once. For example, if H dif is in column G (G2:G100), you could select the range G2:G100 Format/Conditional Formatting Cell Value Is 3 Then click the Format button and select something that will stand out. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|