Spreadsheet: 853748d1703707228-how-to-set-cell-color-based-on-several-factors-help-appreciated-forum-help
Sheet: P&E Tananger

 |  |  |  | 1 - Cannot perform task 2 - Can perform task under supervision 3 - Able to perform task alone 4 - Can train others on tasks/areas 5 - Best in class  Chose your name and position Then fill in the white cells in your column Secondary skill for position is in gray cells |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | George | Fred | [NAME]
 |  |  | Name → | [NAME]
 |  |  | Position → | Instrument engineer
 |  | Position |  | Competence profile | Competence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] matrix
 |  | [NAME] engineer |  | 04. [NAME] | Risk management |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrical engineer
 |  | [NAME] engineer |  | 04. [NAME] | TS - Fire and gas detection |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Main skill | Secondary skill | Tertiary skill |  | Instrument engineer
 |  | [NAME] engineer |  | 04. [NAME] | TS - Fire protection |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] engineer |  | PRE |  | Software engineer
 |  | [NAME] engineer |  | 04. [NAME] | TS - Gas dispersion and explosion |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] engineer |  | Planner
 |  | [NAME] engineer |  | 04. [NAME] | TS - Hazardous Area Classification |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] engineer | Drilling
 |  | [NAME] engineer |  | 04. [NAME] | TS - Ignition Source Control |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] engineer | Offshore
 |  | [NAME] engineer |  | 04. [NAME] | TS - Other |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrical engineer | [NAME] engineer
 |  | [NAME] engineer |  | 04. [NAME] | TS - Passive fire protection |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrical engineer | Instrument engineer
 |  | Electrical engineer |  | 10. Electrical | Atex |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrical engineer |  | PRE
 |  | Electrical engineer |  | 10. Electrical | Rules and Regulations - Electrical Systems |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrical engineer |  | Planner
 |  | Electrical engineer |  | 10. Electrical | Scope definitions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrical engineer |  | Offshore
 |  | Electrical engineer |  | 10. Electrical | Short Circuit Calculations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrical engineer |  | Software engineer
 |  | Electrical engineer |  | 10. Electrical | Shutdown Philosophy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Instrument engineer | [NAME] engineer
 |  | Electrical engineer |  | 10. Electrical | VSD Systems |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Instrument engineer | Electrical engineer
 |  | Electrical engineer |  | 10. Electrical | Work package |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Instrument engineer |  | PRE
 |  | Instrument engineer |  | 11. Instrument | Actuated valves |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  | Instrument engineer |  | Planner
 |  | Instrument engineer |  | 11. Instrument | AT/SJA -Course |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | Instrument engineer |  | Offshore
 |  | Instrument engineer |  | 11. Instrument | Atex |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  | Instrument engineer | Software engineer
 |  | Instrument engineer |  | 11. Instrument | ATEX Courses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Software engineer |  | Electrical engineer
 |  | Instrument engineer |  | 11. Instrument | BUS Communication  Systems |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Software engineer | Instrument engineer
 |  | Instrument engineer |  | 11. Instrument | Cable and Bulk Material Selection |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Software engineer |  | Process
 |  | Instrument engineer |  | 11. Instrument | Calibration |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Software engineer |  | Drilling
 |  | Instrument engineer |  | 11. Instrument | VSD Systems |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Software engineer |  | Planner
 |  | Instrument engineer |  | 11. Instrument | Work Permit system offshore (WP/AT)
 |  | Instrument engineer |  | 11. Instrument | [NAME]
 |  | Software engineer |  | 60. Engineering Software | Inventor
 |  | Software engineer |  | 60. Engineering Software | PDMS Admin
 |  | Software engineer |  | 60. Engineering Software | PDMS user
 |  | NOTE: The following ↓ is a manual edit to show what I want ↑ to look like with the current input. Note the added gray field
 |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | George | Fred | [NAME]
 |  |  | Name → | [NAME]
 |  |  | Position → | Instrument engineer
 |  | Position |  | Competence profile | Competence
 |  | [NAME] engineer |  | 04. [NAME] | Risk management
 |  | [NAME] engineer |  | 04. [NAME] | TS - Fire and gas detection
 |  | [NAME] engineer |  | 04. [NAME] | TS - Fire protection
 |  | [NAME] engineer |  | 04. [NAME] | TS - Gas dispersion and explosion
 |  | [NAME] engineer |  | 04. [NAME] | TS - Hazardous Area Classification
 |  | [NAME] engineer |  | 04. [NAME] | TS - Ignition Source Control
 |  | [NAME] engineer |  | 04. [NAME] | TS - Other
 |  | [NAME] engineer |  | 04. [NAME] | TS - Passive fire protection
 |  | Electrical engineer |  | 10. Electrical | Atex
 |  | Electrical engineer |  | 10. Electrical | Rules and Regulations - Electrical Systems
 |  | Electrical engineer |  | 10. Electrical | Scope definitions
 |  | Electrical engineer |  | 10. Electrical | Short Circuit Calculations
 |  | Electrical engineer |  | 10. Electrical | Shutdown Philosophy
 |  | Electrical engineer |  | 10. Electrical | VSD Systems
 |  | Electrical engineer |  | 10. Electrical | Work package
 |  | Instrument engineer |  | 11. Instrument | Actuated valves
 |  | Instrument engineer |  | 11. Instrument | AT/SJA -Course
 |  | Instrument engineer |  | 11. Instrument | Atex
 |  | Instrument engineer |  | 11. Instrument | ATEX Courses
 |  | Instrument engineer |  | 11. Instrument | BUS Communication  Systems
 |  | Instrument engineer |  | 11. Instrument | Cable and Bulk Material Selection
 |  | Instrument engineer |  | 11. Instrument | Calibration
 |  | Instrument engineer |  | 11. Instrument | VSD Systems
 |  | Instrument engineer |  | 11. Instrument | Work Permit system offshore (WP/AT)
 |  | Instrument engineer |  | 11. Instrument | [NAME]
 |  | Software engineer |  | 60. Engineering Software | Inventor
 |  | Software engineer |  | 60. Engineering Software | PDMS Admin
 |  | Software engineer |  | 60. Engineering Software | PDMS user