Spreadsheet: 106443d1303727086-lookup-of-colored-cells-crane-assement
Sheet: Crane Assessment

No. | DECK  A | HYDRALIFT | SEATRAX | LIEBHERR | [NAME], 7.5T, 36T
1 | Domingo N General | 2012-06-18 00:00:00 | 2012-06-18 00:00:00 | NO CRANE OF THIS TYPE ON A-LOCATION | NO CRANE OF THIS TYPE ON A-LOCATION |  | How do I setup a code/formula to only choose
2 | [NAME] | 2009-07-26 00:00:00 | 2009-07-26 00:00:00 |  |  |  | those cells with red/yellow color.
3 | [NAME] Gador | 2012-06-18 00:00:00 | 2012-06-18 00:00:00 |  |  |  | For example for Deck A there are 6 people with
4 | [NAME] | 2010-05-19 00:00:00 | 2010-05-19 00:00:00 |  |  |  | the HYDRALIFT who needs to attend a new assessment
5 | [NAME] | 2011-07-02 00:00:00 | 2011-07-02 00:00:00 |  |  |  | to have their certificate renewed.
6 | [NAME] | 2012-06-18 00:00:00 | 2012-06-18 00:00:00
7 | Barun [NAME] | 2010-08-18 00:00:00 | 2013-03-27 00:00:00
8 | Grantly Acuzar | 2010-08-20 00:00:00 | 2010-08-20 00:00:00
9 | M G. Pawar | 2012-06-18 00:00:00 | 2012-06-18 00:00:00
10 | [NAME] | 2011-02-06 00:00:00 | 2013-03-27 00:00:00
11 | T Shinoj Rajan | 2011-04-04 00:00:00 | 2011-04-04 00:00:00
12 | Sreekanth V. K | 2011-11-18 00:00:00 | 2011-11-18 00:00:00
13 | [NAME] | 2012-06-18 00:00:00 | 2012-06-18 00:00:00
14 | [NAME] [NAME] | 2011-10-06 00:00:00 | 2011-10-06 00:00:00
15 | Nilo F Pino | 2012-06-18 00:00:00 | 2012-06-18 00:00:00
16 | [NAME] | 2012-04-20 00:00:00 | 2012-04-20 00:00:00
17 | Kadersab Azrecar
No. | DECK  B | HYDRALIFT | SEATRAX | LIEBHERR | [NAME], 7.5T, 36T
18 | [NAME] | 2012-06-15 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2012-04-18 00:00:00
19 | [NAME] | 2012-06-15 00:00:00 | 2012-06-15 00:00:00 | 2012-06-15 00:00:00 | 2012-01-06 00:00:00
20 | Severino Robles | 2012-06-15 00:00:00 | 2012-06-15 00:00:00 | 2012-06-15 00:00:00 | 2012-01-08 00:00:00
21 | Virgillo Aranzanso | 2011-02-09 00:00:00 | 2011-02-09 00:00:00 | 2011-02-09 00:00:00 | 2012-01-07 00:00:00
22 | [NAME] | 2010-10-06 00:00:00 | 2010-10-06 00:00:00 | 2010-10-06 00:00:00 | 2012-04-24 00:00:00
23 | Edsen M Santos | 2010-10-04 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2012-01-05 00:00:00
24 | [NAME] | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00
25 | Rolando A Borja | 2010-10-04 00:00:00 | 2010-10-04 00:00:00 | 2010-10-04 00:00:00 | 2012-01-06 00:00:00
26 | Rolando A Maputi | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2012-04-21 00:00:00
27 | Cristofferson M Egoy | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00
28 | [NAME] | 29.06.2011 | 2012-02-09 00:00:00 | 29.06.2011
29 | [NAME] | 30.06.2011 | 2011-06-30 00:00:00 | 2011-06-30 00:00:00
30 | [NAME] | 2011-11-23 00:00:00 | 2011-11-23 00:00:00 | 2011-11-23 00:00:00 | 2012-04-19 00:00:00
31 | Tranquilino Talon | 2011-10-09 00:00:00 | 2011-10-09 00:00:00 | 2011-10-09 00:00:00 | 2012-01-06 00:00:00
32 | [NAME] | 2011-11-23 00:00:00 | 2011-11-23 00:00:00 | 2011-11-23 00:00:00 | 2012-04-19 00:00:00
33 | [NAME] |  | 2011-10-09 00:00:00 | 2011-10-09 00:00:00 | 2012-01-04 00:00:00
34 | [NAME] | 2011-02-09 00:00:00 | 2011-02-09 00:00:00 | 2011-02-09 00:00:00 | 2012-01-04 00:00:00
35 | [NAME] | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00
36 | [NAME] | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00
37 | [NAME] | 2013-03-27 00:00:00 |  | 2013-03-27 00:00:00 | 2013-03-27 00:00:00
38 | [NAME] |  | 2012-06-15 00:00:00
39 | [NAME] | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00
40 | Orlando P Pareja | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00
41 | [NAME] | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00
No. | DECK  C | HYDRALIFT | SEATRAX | Liebherr | [NAME], 7.5T, 36T
42 | Sudesh [NAME] |  |  |  | NO CRANE OF THIS TYPE ON C-LOCATION
43 | [NAME] | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00
44 | [NAME]/o | 2012-06-20 00:00:00 | 2012-06-20 00:00:00
45 | [NAME] | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00
46 | [NAME] | 2012-06-20 00:00:00 | 2012-06-20 00:00:00
47 | Balasubramanian | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00
48 | Rolando Patalita | 2011-02-09 00:00:00 | 2011-02-09 00:00:00 | 2011-02-09 00:00:00
49 | [NAME] | 2012-06-20 00:00:00 | 2011-10-10 00:00:00 | 2011-10-10 00:00:00
50 | [NAME] | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00
51 | Calixto L Magdadaro | 2013-03-27 00:00:00 | 2013-03-27 00:00:00 | 2013-03-27 00:00:00