Spreadsheet: 765204d1643209361-apply-conditional-formatting-based-on-id-numbers-odd-even-rule-cannot-be-applied-conditional-formatting-solution
Sheet: CondFormatting

ID | F1 | F2 | F3 | FIELDNAME | Match_F1 | Match_F2 | Match_F3 | HelperColumn
1 | Inspection | ID |  | IRMAP_INSPECTION_ID | -1 | -1
1 | Inspection | ID |  | REC_INSPECTION_ID | -1 | -1
1 | Inspection | ID |  | RIT2_INSPECTION_TYPE_TIER1_ID | -1 | -1
2 | Category |  |  | DMQ_CATEGORY_ID | -1
2 | Category |  |  | DMQ_MDS_AFSC_CATEGORY_ID | -1
2 | Category |  |  | DMQ_MDS_DOD_CATEGORY_ID | -1
2 | Category |  |  | DMQ_SUBCATEGORY1_ID | -1
2 | Category |  |  | DMQ_SUBCATEGORY2_ID | -1
2 | Category |  |  | DRQ_INCLUDE_CROSS_CATEGORY_FL | -1
2 | Category |  |  | DRQ_MDS_CATEGORY | -1
2 | Category |  |  | DRQ_MDS_CATEGORY_ID | -1
2 | Category |  |  | [NAME] | -1
2 | Category |  |  | DRQ_MISHAP_CATEGORY_ID | -1
2 | Category |  |  | DRQ_MISHAP_SUBCATEGORY | -1
2 | Category |  |  | DRQ_MISHAP_SUBCATEGORY_ID | -1
2 | Category |  |  | FEEDB_CATEGORY_TIER1_ID | -1
2 | Category |  |  | MR_HULL_CATEGORY_ID | -1
2 | Category |  |  | MR_MDS_CATEGORY_ID | -1
2 | Category |  |  | MRS_SUBCATEGORY_ID | -1
2 | Category |  |  | MSG_CATEGORY_ID | -1
2 | Category |  |  | MSG_SUBCATEGORY_ID | -1
2 | Category |  |  | MSHP_CATEGORY_ID | -1
2 | Category |  |  | MSHP_CROSS_CATEGORY_ID | -1
2 | Category |  |  | MSHP_CROSS_SUBCATEGORY_ID | -1
2 | Category |  |  | MSHP_SUBCATEGORY_ID | -1
2 | Category |  |  | [NAME] | -1
2 | Category |  |  | MSHPL_CATEGORY_FROM | -1
2 | Category |  |  | MSHPL_CATEGORY_ID_FROM | -1
2 | Category |  |  | MSHPL_CATEGORY_ID_TO | -1
2 | Category |  |  | MSHPL_CATEGORY_TO | -1
2 | Category |  |  | MSHPL_SUBCATEGORY_FROM | -1
2 | Category |  |  | MSHPL_SUBCATEGORY_ID_FROM | -1
2 | Category |  |  | MSHPL_SUBCATEGORY_ID_TO | -1
2 | Category |  |  | MSHPL_SUBCATEGORY_TO | -1
2 | Category |  |  | RCLT_PERSONNEL_CATEGORY_ID | -1
2 | Category |  |  | REC_CATEGORY_ID | -1
2 | Category |  |  | REC_HAZARD_CATEGORY_ID | -1
2 | Category |  |  | RFLT_FILE_CATEGORY_ID | -1
2 | Category |  |  | RFW_SUBCATEGORY_ID | -1
2 | Category |  |  | RIC_PERSONNEL_CATEGORY_ID | -1
2 | Category |  |  | RICM_CATEGORY_ID | -1
2 | Category |  |  | RICPD_PERSONNEL_CATEGORY_ID | -1
2 | Category |  |  | RMP_CATEGORY_ID | -1
2 | Category |  |  | RMP_SUBCATEGORY_ID | -1
2 | Category |  |  | RMTM_CATEGORY_ID | -1
2 | Category |  |  | RMTM_SUBCATEGORY_ID | -1
2 | Category |  |  | RMXR_CATEGORY_ID | -1
2 | Category |  |  | ROT2_DOD_MDS_CATEGORY_ID | -1
2 | Category |  |  | ROT2_HULL_CATEGORY_ID | -1
2 | Category |  |  | ROT2_MDS_CATEGORY_ID | -1
2 | Category |  |  | RRHI_RISK_CATEGORY | -1
2 | Category |  |  | RSCAT2_SUBCATEGORY_ID | -1
2 | Category |  |  | RTCM_FILE_CATEGORY_ID | -1
5 | Installation |  |  | DOQ_ASSG_INSTALLATION1 | -1
5 | Installation |  |  | DOQ_ASSG_INSTALLATION1_ID | -1
5 | Installation |  |  | DOQ_ASSG_INSTALLATION2 | -1
5 | Installation |  |  | DOQ_ASSG_INSTALLATION2_ID | -1
5 | Installation |  |  | DOQ_ASSG_INSTALLATION3 | -1
5 | Installation |  |  | DOQ_ASSG_INSTALLATION3_ID | -1
5 | Installation |  |  | LOC_MILES_FROM_INSTALLATION | -1
5 | Installation |  |  | LOC_NEAREST_INSTALLATION_ID | -1
5 | Installation |  |  | RFAC_INSTALLATION_NAME | -1
5 | Installation |  |  | RFAC_INSTALLATION_UIC | -1
5 | Installation |  |  | RGHS_INSTALLATION_ID | -1
5 | Installation |  |  | RORG_INSTALLATION_ID | -1
6 | Status |  |  | ACFT_BACKGROUND_STATUS_ID | -1
6 | Status |  |  | ACFT_COCKPIT_STATUS_ID | -1
6 | Status |  |  | ACFT_FORM_LIGHT_STATUS_ID | -1
6 | Status |  |  | ACOMP_OVERHAUL_STATUS_ID | -1
6 | Status |  |  | BASH_AVIAN_RADAR_STATUS_ID | -1
6 | Status |  |  | DF_VIRUS_SCAN_STATUS_ID | -1
6 | Status |  |  | DIQ_EMPLOYMENT_STATUS1_ID | -1
6 | Status |  |  | DIQ_EMPLOYMENT_STATUS2_ID | -1
6 | Status |  |  | DMQ_DUTY_STATUS1_ID | -1
6 | Status |  |  | DMQ_DUTY_STATUS2_ID | -1
6 | Status |  |  | [NAME] | -1
6 | Status |  |  | DMQ_ON_DUTY_STATUS_FLAG | -1
6 | Status |  |  | DRQ_ON_DUTY_STATUS_FLAG | -1
6 | Status |  |  | DRQ_REC_STATUS_BIT_FLAG | -1
6 | Status |  |  | EMLR_STATUS_ID | -1
6 | Status |  |  | FCTM_DUTY_STATUS | -1
6 | Status |  |  | FCTM_LAST_MSG_STATUS_DESC | -1
6 | Status |  |  | FCTM_MISHAP_STATUS_DESCRIPTION | -1
6 | Status |  |  | FCTM_MOFE_STATUS_DESCRIPTION | -1
6 | Status |  |  | FCTM_MOFE_STATUS_ID | -1
6 | Status |  |  | FCTM_REPORT_STATUS_DESCRIPTION | -1
6 | Status |  |  | FCTMC_COMMENT_STATUS_DESC | -1
6 | Status |  |  | FCTMC_COMMENT_STATUS_ID | -1
6 | Status |  |  | FCTMT_TAB_STATUS_DESCRIPTION | -1
6 | Status |  |  | FCTMT_TAB_STATUS_ID | -1
6 | Status |  |  | FEEDB_STATUS_ID | -1
6 | Status |  |  | FSI_STATUS_ID | -1
6 | Status |  |  | JAQ_STATUS_DATE | -1
6 | Status |  |  | MINV_COORDINATION_STATUS_FLAG | -1
6 | Status |  |  | MOFE_STATUS_ID | -1
6 | Status |  |  | MOFQ_COMMENT_STATUS_ID | -1
6 | Status |  |  | MQR_STATUS_ID | -1
6 | Status |  |  | MRDS_DUTY_STATUS_ID | -1
6 | Status |  |  | [NAME] | -1
6 | Status |  |  | MSG_STATUS_REASON_ID | -1
6 | Status |  |  | MSHP_MISHAP_STATUS_ID | -1
6 | Status |  |  | MSHP_REPORT_STATUS_ID | -1
6 | Status |  |  | OML_STATUS | -1
6 | Status |  |  | PERS_CONT_TRAIN_STATUS_FLAG | -1
6 | Status |  |  | PERS_DUTY_STATUS_TIER1_ID | -1
6 | Status |  |  | PERS_DUTY_STATUS_TIER2_ID | -1
6 | Status |  |  | PERS_EMPLOYMENT_STATUS1_ID | -1
6 | Status |  |  | PERS_EMPLOYMENT_STATUS2_ID | -1
6 | Status |  |  | PERS_ON_FLYING_STATUS_FLAG | -1
6 | Status |  |  | PERS_STUDENT_STATUS_FLAG | -1
6 | Status |  |  | PHY_MARITAL_STATUS_ID | -1
6 | Status |  |  | QCE_EVALUATION_STATUS_ID | -1
6 | Status |  |  | RDSM_DUTY_STATUS_TIER1_ID | -1
6 | Status |  |  | RDSM_DUTY_STATUS_TIER2_ID | -1
6 | Status |  |  | REC_HAZARD_PROJECT_STATUS_ID | -1
6 | Status |  |  | REC_STATUS_ID | -1
6 | Status |  |  | RES2_EMP_STATUS_TIER1_ID | -1
6 | Status |  |  | RNLS_LIGHT_STATUS_FLAG | -1
6 | Status |  |  | RPPSM_PATH_STATUS_ID | -1
6 | Status |  |  | RRES2M_EMPLOY_STATUS_2_ID | -1
6 | Status |  |  | RS_STATUS_ID | -1
6 | Status |  |  | [NAME] | -1
6 | Status |  |  | RSN_SHIP_DISPOSITION_STATUS_ID | -1
6 | Status |  |  | SHIP_STATUS_OF_SHIP_ID | -1
6 | Status |  |  | TA_REQUEST_STATUS_ID | -1
6 | Status |  |  | TAT_TAB_ACCESS_STATUS_ID | -1
6 | Status |  |  | VO_LICENSE_STATUS_ID | -1
6 | Status |  |  | WR_WAIVER_STATUS_ID | -1
6 | Status |  |  | WRT_TAB_WAIVER_STATUS_ID | -1
8 | Inspector |  |  | DINSPQ_INSPECTOR_DESC | -1
8 | Inspector |  |  | DINSPQ_INSPECTOR_ID | -1
10 | Created | By |  | DIVE_ACTIVITY_CREATED_BY | -1 | -1
10 | Created | By |  | JUMPER_CREATED_BY | -1 | -1
16 | [NAME] |  |  | AHFO_HAZARD_FOREIGN_OBJ_ID | -1
16 | [NAME] |  |  | DINSPQ_ASSOCIATED_HAZARDS | -1
16 | [NAME] |  |  | DINSPQ_HAZARDS_FLAG | -1
16 | [NAME] |  |  | DIQ_HAZARD_TYPE_ID | -1
16 | [NAME] |  |  | DRQ_KEYWORD_ON_HAZARD_FLAG | -1
16 | [NAME] |  |  | MSHP_HAZARD_SEVERITY_ID | -1
16 | [NAME] |  |  | MSHP_HAZARD_VALIDATION_ID | -1
16 | [NAME] |  |  | PERS_HAZARD_DESCRIPTION | -1
16 | [NAME] |  |  | PERS_KNOWN_HAZARD_EXPOSURE_FLAG | -1
16 | [NAME] |  |  | PILL_HAZARD_TYPE_ID | -1
16 | [NAME] |  |  | REC_HAZARD_ABATEMENT_ACTION | -1
16 | [NAME] |  |  | REC_HAZARD_CATEGORY_ID | -1
16 | [NAME] |  |  | REC_HAZARD_CORRECTED_FLAG | -1
16 | [NAME] |  |  | REC_HAZARD_DISCOVERY_METHOD_ID | -1
16 | [NAME] |  |  | REC_HAZARD_PROJECT_COST | -1
16 | [NAME] |  |  | REC_HAZARD_PROJECT_STATUS_ID | -1
16 | [NAME] |  |  | REC_HAZARD_PROJECT_WORK_ORDER | -1
16 | [NAME] |  |  | REC_HAZARD_TYPE_ID | -1
20 | Severity |  |  | DIQ_ILLNESS_SEVERITY_ID | -1
20 | Severity |  |  | DMQ_INJURY_SEVERITY_ID | -1
20 | Severity |  |  | FEEDB_SEVERITY_ID | -1
20 | Severity |  |  | MSHP_HAZARD_SEVERITY_ID | -1
20 | Severity |  |  | PERS_INJURY_SEVERITY_ID | -1
20 | Severity |  |  | RAC_SEVERITY_ID | -1
20 | Severity |  |  | RHI_CURRENT_SEVERITY_ID | -1
20 | Severity |  |  | [NAME] | -1
20 | Severity |  |  | RRAC_SEVERITY_ID | -1
20 | Severity |  |  | RRHI_SEVERITY_ID | -1
21 | Probability |  |  | RAC_PROBABILITY_ID | -1
21 | Probability |  |  | [NAME] | -1
21 | Probability |  |  | RHI_RESIDUAL_PROBABILITY_ID | -1
21 | Probability |  |  | RRAC_PROBABILITY_ID | -1
21 | Probability |  |  | RRHI_PROBABILITY_ID | -1
23 | RAC |  |  | AEGR_CAUSE_PARACHUTE_DAMAGE_ID | -1
23 | RAC |  |  | AEGR_DRAGGED_PARACHUTE_FLAG | -1
23 | RAC |  |  | AEGR_NUM_PREV_PARACHUTE_JUMPS | -1
23 | RAC |  |  | [NAME] | -1
23 | RAC |  |  | AEGR_PARACHUTE_FUNCTION_ID | -1
23 | RAC |  |  | AEGR_PARACHUTE_OSC_SEV_ID | -1
23 | RAC |  |  | AEGR_TYPE_PARACHUTE_ID | -1
23 | RAC |  |  | CARGO_NUMBER_EXTRACTION_PARACHUTES | -1
23 | RAC |  |  | CARGO_PARACHUTE_NUMBER_JUMPS_DROPS | -1
23 | RAC |  |  | DOQ_ON_DUTY_CONTRACTOR_FLAG | -1
23 | RAC |  |  | DRQ_RAC_BIT_FIELD | -1
23 | RAC |  |  | MSHP_CONTRACTOR_FLAG | -1
23 | RAC |  |  | OBJ_HOW_PARACHUTE_PACKED_ID | -1
23 | RAC |  |  | OBJ_MAIN_PARACHUTE_FLAG | -1
23 | RAC |  |  | OBJ_PARACHUTE_AGE | -1
23 | RAC |  |  | OBJ_PARACHUTE_DATE_OF_MANUFACTURE | -1
23 | RAC |  |  | OBJ_PARACHUTE_NUMBER_DROPS | -1
23 | RAC |  |  | OBJ_PARACHUTE_PACKED_BY_DOD_ID | -1
23 | RAC |  |  | OBJ_PARACHUTE_PLACED_IN_SERVICE_DATE | -1
23 | RAC |  |  | OBJ_PARACHUTE_REPACK_DATE | -1
23 | RAC |  |  | OBJ_PARACHUTE_SERIAL_NUMBER | -1
23 | RAC |  |  | OBJ_TRACKING_NUMBER | -1
23 | RAC |  |  | OCOST_DEPOT_CONTRACTOR | -1
23 | RAC |  |  | OCOST_FIELD_CONTRACTOR | -1
23 | RAC |  |  | PHY_GREEN_TEA_EXTRACT_FLAG | -1
23 | RAC |  |  | [NAME] | -1
23 | RAC |  |  | RAC_ABATEMENT_COST | -1
23 | RAC |  |  | RAC_ENTRY_DATE | -1
23 | RAC |  |  | RAC_ENTRY_USER_ID | -1
23 | RAC |  |  | RAC_EXPOSURE | -1
23 | RAC |  |  | RAC_ID | -1
23 | RAC |  |  | RAC_LAST_UPDATE_DATE | -1
23 | RAC |  |  | RAC_LAST_UPDATE_USER_ID | -1
23 | RAC |  |  | RAC_PROBABILITY_ID | -1
23 | RAC |  |  | RAC_RAC | -1
23 | RAC |  |  | RAC_SEVERITY_ID | -1
23 | RAC |  |  | RACP_ACTIVE_FLAG | -1
23 | RAC |  |  | RACP_CODE | -1
23 | RAC |  |  | RACP_DESCRIPTION | -1
23 | RAC |  |  | RACP_ID | -1
23 | RAC |  |  | RACP_SORT_NUMBER | -1
23 | RAC |  |  | RACS_ACTIVE_FLAG | -1
23 | RAC |  |  | RACS_CODE | -1
23 | RAC |  |  | [NAME] | -1
23 | RAC |  |  | RACS_ID | -1
23 | RAC |  |  | RACS_SORT_NUMBER | -1
23 | RAC |  |  | RACT1_ACTIVE_FLAG | -1
23 | RAC |  |  | RACT1_CODE | -1
23 | RAC |  |  | RACT1_DESCRIPTION | -1
23 | RAC |  |  | RACT1_ID | -1
23 | RAC |  |  | RACT1_SORT_NUMBER | -1
23 | RAC |  |  | [NAME] | -1
23 | RAC |  |  | RACT2_ACTIVITY_TIER1_ID | -1
23 | RAC |  |  | RACT2_CODE | -1
23 | RAC |  |  | RACT2_DESCRIPTION | -1
23 | RAC |  |  | RACT2_ID | -1
23 | RAC |  |  | RACT2_SORT_NUMBER | -1
23 | RAC |  |  | RACT3_ACTIVE_FLAG | -1
23 | RAC |  |  | RACT3_ACTIVITY_TIER2_ID | -1
23 | RAC |  |  | RACT3_CODE | -1
23 | RAC |  |  | RACT3_DESCRIPTION | -1
23 | RAC |  |  | RACT3_ID | -1
23 | RAC |  |  | RACT3_SORT_NUMBER | -1
23 | RAC |  |  | RDDT2_DRIVER_DISTRACT_TIER1_ID | -1
23 | RAC |  |  | RDGS_STACK_TRACE_EXCEPTION | -1
23 | RAC |  |  | RDGS_STACK_TRACE_MESSAGE | -1
23 | RAC |  |  | REC_RAC_ID | -1
23 | RAC |  |  | RRAC_DESCRIPTION | -1
23 | RAC |  |  | RRAC_MULTIPLIER | -1
23 | RAC |  |  | RRAC_PROBABILITY_ID | -1
23 | RAC |  |  | RRAC_RISK_ASSESSMENT_CODE | -1
23 | RAC |  |  | RRAC_SEVERITY_ID | -1
23 | RAC |  |  | VO_DISTRACTION_OTHER | -1
23 | RAC |  |  | VO_DISTRACTION_TIER1_ID | -1
23 | RAC |  |  | VO_DISTRACTION_TIER2_ID | -1
23 | RAC |  |  | VO_OPERATOR_DISTRACTED_FLAG | -1
24 | Severity |  |  | DIQ_ILLNESS_SEVERITY_ID | -1
24 | Severity |  |  | DMQ_INJURY_SEVERITY_ID | -1
24 | Severity |  |  | FEEDB_SEVERITY_ID | -1
24 | Severity |  |  | MSHP_HAZARD_SEVERITY_ID | -1
24 | Severity |  |  | PERS_INJURY_SEVERITY_ID | -1
24 | Severity |  |  | RAC_SEVERITY_ID | -1
24 | Severity |  |  | RHI_CURRENT_SEVERITY_ID | -1
24 | Severity |  |  | [NAME] | -1
24 | Severity |  |  | RRAC_SEVERITY_ID | -1
24 | Severity |  |  | RRHI_SEVERITY_ID | -1
25 | Probability |  |  | RAC_PROBABILITY_ID | -1
25 | Probability |  |  | [NAME] | -1
25 | Probability |  |  | RHI_RESIDUAL_PROBABILITY_ID | -1
25 | Probability |  |  | RRAC_PROBABILITY_ID | -1
25 | Probability |  |  | RRHI_PROBABILITY_ID | -1