#1
|
|||
|
|||
Creating multiple conditional rules on one column
there are 3 different age intervals. consequently the lab result of the older children are prone to show high interval. the age between 0-3 shows results between 60-360 whereas the age between 3-9 shows results between 100-600. we seperated them according to their intervals of the results however as the interval varies there may be an overlapping interval. We need the excell to show us the optimum result and indicate if the result is abnormal for that interval yet
normal for another interval. Group A 200-900 normal Group B 60-360 normal Group C 120-600 normal If i write A 150 it needs to show black, but if i write same value with A that must be yellow. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple Row Headings and Last Column Alignment | Pecan | Word Tables | 6 | 09-13-2013 12:20 PM |
Creating rules | donnavoytko | Outlook | 1 | 07-31-2012 05:54 AM |
Creating Rules to block Senders by "Nickname" rather than email address | RavnResn | Outlook | 1 | 05-24-2011 01:35 AM |
multiple colums under a single column | RobotChicken | Excel | 3 | 01-06-2010 09:17 AM |
I need help creating an extra column EASY question :) Please | soapage | Word | 2 | 03-16-2009 05:16 PM |