Spreadsheet: 672418d1586866859-conditional-formatting-of-vertical-list-ward-4
Sheet: Sheet1

 | LOWER |  | UPPER |  |  |  | LOWER |  | UPPER
 | BUILDING AND ROOM LAYOUT |  |  |  |  |  | BUILDING AND ROOM LAYOUT |  |  |  |  | DATA INPUT |  |  |  | DATA INPUT |  |  |  | DATA INPUT |  |  |  | DATA INPUT
 | 401 |  |  |  |  |  | 402 |  |  |  |  | 401 |  |  |  | 402 |  |  |  | 403 |  |  |  | 404
 | 12 | 13 | 36 | 37 |  |  | 12 | 13 | 36 | 37 |  | 401 | 1 | CAT1 |  | 402 | 1 | CAT1 |  | 401 | 1 | CAT1 |  | 402 | 1 | CAT1
 | 11 | 14 | 35 | 38 |  |  | 11 | 14 | 35 | 38 |  |  | 2 | CAT1 |  |  | 2 | CAT1 |  |  | 2 | CAT1 |  |  | 2 | CAT1
 | 10 | 15 | 34 | 39 |  |  | 10 | 15 | 34 | 39 |  |  | 3 | CAT1 |  |  | 3 | CAT1 |  |  | 3 | CAT1 |  |  | 3 | CAT1
 | 9 | 16 | 33 | 40 |  |  | 9 | 16 | 33 | 40 |  |  | 4 | CAT1 |  |  | 4 | CAT1 |  |  | 4 | CAT1 |  |  | 4 | CAT1
 | 8 | 17 | 32 | 41 |  |  | 8 | 17 | 32 | 41 |  |  | 5 |  |  |  | 5 |  |  |  | 5 |  |  |  | 5
 | 7 | 18 | 31 | 42 |  |  | 7 | 18 | 31 | 42 |  |  | 6 |  |  |  | 6 |  |  |  | 6 |  |  |  | 6
 | 6 | 19 | 30 | 43 |  |  | 6 | 19 | 30 | 43 |  |  | 7 | CAT2 |  |  | 7 | CAT2 |  |  | 7 | CAT2 |  |  | 7 | CAT2
 | 5 | 20 | 29 | 44 |  |  | 5 | 20 | 29 | 44 |  |  | 8 | CAT2 |  |  | 8 | CAT2 |  |  | 8 | CAT2 |  |  | 8 | CAT2
 | 4 | 21 | 28 | 45 |  |  | 4 | 21 | 28 | 45 |  |  | 9 | CAT3 |  |  | 9 | CAT3 |  |  | 9 | CAT3 |  |  | 9 | CAT3
 | 3 | 22 | 27 | 46 |  |  | 3 | 22 | 27 | 46 |  |  | 10 | CAT3 |  |  | 10 | CAT3 |  |  | 10 | CAT3 |  |  | 10 | CAT3
 | 2 | 23 | 26 | 47 |  |  | 2 | 23 | 26 | 47 |  |  | 11 | CAT3 |  |  | 11 | CAT3 |  |  | 11 | CAT3 |  |  | 11 | CAT1
 | 1 | 24 | 25 | 48 |  |  | 1 | 24 | 25 | 48 |  |  | 12 | CAT3 |  |  | 12 | CAT3 |  |  | 12 | CAT3 |  |  | 12 | CAT1
 |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  |  |  | 13 |  |  |  | 13 | CAT3 |  |  | 13 | CAT1
 | 2020-03-04 00:00:00 |  |  |  |  |  | 2020-04-04 00:00:00 |  |  |  |  |  | 14 |  |  |  | 14 |  |  |  | 14 | CAT3 |  |  | 14 | CAT1
 | 13 | 12 | 37 | 36 |  |  | 13 | 12 | 37 | 36 |  |  | 15 |  |  |  | 15 |  |  |  | 15 | CAT3 |  |  | 15 | CAT1
 | 14 | 11 | 38 | 35 |  |  | 14 | 11 | 38 | 35 |  |  | 16 |  |  |  | 16 |  |  |  | 16 | CAT3 |  |  | 16 | CAT1
 | 15 | 10 | 39 | 34 |  |  | 15 | 10 | 39 | 34 |  |  | 17 |  |  |  | 17 | CAT3 |  |  | 17 |  |  |  | 17 | CAT1
 | 16 | 9 | 40 | 33 |  |  | 16 | 9 | 40 | 33 |  |  | 18 |  |  |  | 18 | CAT3 |  |  | 18 |  |  |  | 18 | CAT1
 | 17 | 8 | 41 | 32 |  |  | 17 | 8 | 41 | 32 |  |  | 19 | CAT1 |  |  | 19 |  |  |  | 19 |  |  |  | 19 | CAT1
 | 18 | 7 | 42 | 31 |  |  | 18 | 7 | 42 | 31 |  |  | 20 | CAT0 |  |  | 20 |  |  |  | 20 |  |  |  | 20 | CAT1
 | 19 | 6 | 43 | 30 |  |  | 19 | 6 | 43 | 30 |  |  | 21 | CAT1 |  |  | 21 |  |  |  | 21 | CAT1 |  |  | 21
 | 20 | 5 | 44 | 29 |  |  | 20 | 5 | 44 | 29 |  |  | 22 |  |  |  | 22 |  |  |  | 22 |  |  |  | 22
 | 21 | 4 | 45 | 28 |  |  | 21 | 4 | 45 | 28 |  |  | 23 |  |  |  | 23 |  |  |  | 23 |  |  |  | 23
 | 22 | 3 | 46 | 27 |  |  | 22 | 3 | 46 | 27 |  |  | 24 | CAT2 |  |  | 24 |  |  |  | 24 | CAT2 |  |  | 24
 | 23 | 2 | 47 | 26 |  |  | 23 | 2 | 47 | 26 |  |  | 25 | CAT2 |  |  | 25 |  |  |  | 25 | CAT2 |  |  | 25
 | 24 | 1 | 48 | 25 |  |  | 24 | 1 | 48 | 25 |  |  | 26 |  |  |  | 26 |  |  |  | 26 |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  | 27 |  |  |  | 27 |  |  |  | 27 |  |  |  | 27
 |  | RULE | FORMAT | Applies To |  |  |  |  |  |  |  |  | 28 |  |  |  | 28 |  |  |  | 28 |  |  |  | 28
 | $P5="CAT1" |  |  | $B$5:$B$16 |  |  |  |  |  |  |  |  | 29 |  |  |  | 29 |  |  |  | 29 |  |  |  | 29
 | $P5="CAT2" |  |  | $B$5:$B$16 |  |  |  |  |  |  |  |  | 30 |  |  |  | 30 | CAT1 |  |  | 30 |  |  |  | 30 | CAT1
 | $P5="CAT3" |  |  | $B$5:$B$16 |  |  |  |  |  |  |  |  | 31 |  |  |  | 31 | CAT1 |  |  | 31 |  |  |  | 31 | CAT1
 |  |  |  |  |  |  |  |  |  |  |  |  | 32 |  |  |  | 32 |  |  |  | 32 |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  | 33 |  |  |  | 33 | CAT3 |  |  | 33 |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  |  |  | 34 |  |  |  | 34 | CAT3 |  |  | 34 |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  | 35 | CAT2 |  |  | 35 | CAT3 |  |  | 35 |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  | 36 | CAT2 |  |  | 36 | CAT3 |  |  | 36 |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  | 37 | CAT2 |  |  | 37 | CAT3 |  |  | 37 |  |  |  | 37
 |  |  |  |  |  |  |  |  |  |  |  |  | 38 | CAT2 |  |  | 38 |  |  |  | 38 |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  |  | 39 | CAT2 |  |  | 39 |  |  |  | 39 |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  |  |  | 40 | CAT2 |  |  | 40 |  |  |  | 40 |  |  |  | 40 | CAT3
 |  |  |  |  |  |  |  |  |  |  |  |  | 41 |  |  |  | 41 |  |  |  | 41 |  |  |  | 41 | CAT3
 |  |  |  |  |  |  |  |  |  |  |  |  | 42 |  |  |  | 42 |  |  |  | 42 |  |  |  | 42
 |  |  |  |  |  |  |  |  |  |  |  |  | 43 |  |  |  | 43 |  |  |  | 43 | CAT3 |  |  | 43
 |  |  |  |  |  |  |  |  |  |  |  |  | 44 |  |  |  | 44 |  |  |  | 44 | CAT3 |  |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  | 45 |  |  |  | 45 | CAT3 |  |  | 45
 |  |  |  |  |  |  |  |  |  |  |  |  | 46 |  |  |  | 46 |  |  |  | 46 | CAT3 |  |  | 46 | CAT3
 |  |  |  |  |  |  |  |  |  |  |  |  | 47 |  |  |  | 47 |  |  |  | 47 | CAT3 |  |  | 47 | CAT3
 |  |  |  |  |  |  |  |  |  |  |  |  | 48 |  |  |  | 48 |  |  |  | 48 |  |  |  | 48