Spreadsheet: 168851d1342608187-if-statements-or-conditional-formatting-test-colleagues
Sheet: Test

Which Preferences | First Preference Job Number | Second Preference Job Number | Third Preference Job Number
 | GFO007918 | GFO007773 | GFO007686
 | GFO007878 | GFO007855 | GFO008296
 | GFO008358 | GFO008312 | GFO008334
 | GFO007906 | [NAME] | GFO008322
 | GFO007976 | GFO007811 | GFO007752
 | GFO007687 | GFO008005
 | GFO007773 | GFO007679 | GFO008327
 | GFO007773 | GFO008081 | GFO008080
 | GFO007772
 | GFO007800 | GFO007689 | GFO007940
 | [NAME] | GFO007779 | GFO007932
 | [NAME] | GFO008272 | GFO007699
 | [NAME] | [NAME] | GFO007801
 | GFO007778 | [NAME] | GFO008272
 | GFO007784 | GFO007785 | GFO007777
 | GFO007779 | GFO007839 | GFO007784
 | GFO007777 | [NAME] | GFO007804
 | [NAME] | GFO008291 | GFO007801
 | GFO007785 | GFO007784 | [NAME]
 | [NAME] | GFO007787 | GFO008096
 | [NAME] | GFO007787 | GFO008096
 | [NAME] | GFO007787 | GFO007779
 | GFO007688 | GFO008341 | GFO007777
 | GFO007785 | GFO007784 | GFO007778
 | GFO008033 | GFO008016 | GFO008006
 | [NAME] | GFO008006 | GFO007800
 | [NAME] | GFO007940
 | GFO007936 | GFO007823 | GFO007779
 | GFO007953 | GFO007961 | GFO007806
 | GFO008053 | GFO008057 | GFO007961
 | [NAME] | GFO007777 | GFO008034
 | [NAME] | GFO007788 | GFO007808
 | GFO007788 | GFO008057 | GFO007874
 | GFO007788 | GFO008053 | GFO007808
 | GFO007788 | GFO007789 | GFO008057
 | GFO007806 | [NAME] | GFO007809
 | GFO007808 | GFO007961 | GFO007955
 | GFO007788 | GFO008044 | GFO008057
 | GFO007793 | GFO007808 | GFO007806
 | GFO008312 | GFO008221 | GFO008313
 | GFO007797
 | GFO007788 | GFO007789 | GFO007798
 | GFO007799 | GFO007796 | GFO007797
 | GFO007791 | GFO007971 | GFO007797
 | GFO007789 | GFO007971 | GFO008245
 | GFO007797 | [NAME] | GFO008245
 | GFO007797 | GFO007788 | GFO008321
 | GFO007796 | GFO007797 | GFO007791
 | GFO007796 | GFO007797 | GFO007789
 | GFO007788 | GFO007791 | GFO007789
 | GFO008345 | GFO007809
 | GFO007791 | GFO008229 | GFO007797
 | GFO007789 | GFO007788 | [NAME]
 | GFO007789 | GFO007798 | GFO007797
 | GFO007789 | GFO007798 | GFO007788
 | GFO007778
 | GFO007789 | GFO007798 | GFO007972
 | GFO007793 | GFO007798 | GFO007799
 | GFO008334 | GFO008358 | GFO008223
 | GFO007788 | GFO007791 | GFO007792
 | GFO007789 | GFO007797 | GFO007806
 | GFO007789 | GFO007971 | GFO007700
 | GFO007788 | GFO007798 | GFO007797
 | GFO007788 | GFO007964 | GFO007806
 | GFO007788 | GFO007797 | GFO007718
 | GFO007798 | GFO007797 | GFO007809
 | GFO007798 | GFO007799 | GFO007788
 | GFO007799 | GFO007797
 | GFO008257 | GFO007955 | GFO007799
 | GFO007799 | GFO007797 | GFO007808
 | GFO007799 | GFO007797 | GFO007788
 | GFO007789 | GFO007797 | GFO007798
 | GFO007789 | GFO007798 | GFO007964
 | GFO008334
 | GFO007798 | GFO007788 | GFO008229
 | GFO008334 | GFO008223
 | GFO007788 | GFO007791 | GFO007789
 | GFO007789 | GFO007791 | GFO008265
 | GFO007788 | GFO007791
 | GFO007811 | GFO007814 | GFO007813
 | GFO007815 | GFO007976 | GFO007811
 | GFO007741 | GFO008163 | GFO007742
 | GFO007791
 | GFO007788 | GFO007797 | GFO007798
 | GFO007797 | GFO007789 | GFO007798
 | [NAME]
 | GFO007788
 | GFO007790
 | GFO007797
 | GFO007778
 |  | GFO007797 | GFO007788
 |  | GFO007797
 | GFO007687 | GFO008005
 | GFO008076
 | GFO007772 | GFO008001 | GFO007999
 | GFO007783 | GFO007930 | GFO007786
 | GFO007786 | GFO007780 | GFO007783
 | GFO007780 | GFO007786
 | GFO008282 | GFO008281 | GFO007780
 | GFO007782 | GFO008097 | GFO008333
 | GFO007699
 | GFO008282 | GFO008281 | GFO007801
 | GFO008281 | GFO008282 | GFO007699
 | GFO007782 | GFO008308 | GFO007946
 | GFO007808 | [NAME] | GFO008055
 | GFO007863 | GFO007951 | GFO007799
 | GFO008226 | GFO008334 | GFO008046
 | GFO008257 | [NAME]
 | GFO007809 | GFO008058 | GFO007713
 | GFO007776
 | GFO007776 | GFO007811 | GFO007976
 | GFO007776 | GFO007976 | GFO007811
 | GFO008160 | GFO007811 | GFO007741
 | GFO007772 | GFO007771 | GFO007684
 | GFO007771 | GFO007772 | GFO008079
 | GFO007920 | GFO007771 | GFO007772
 | GFO007772 | GFO007771 | GFO007999
 | [NAME] | GFO007801 | GFO008293
 | GFO007794 | GFO008237 | GFO008336
 | GFO007794
 | [NAME] | GFO007806 | GFO007808
 | GFO008298 | GFO008040 | GFO007702
 | GFO007794 | [NAME] | GFO007963
 | [NAME]
 | GFO008055 | [NAME] | [NAME]