Spreadsheet: 96068d1295534992-if-cell-colour-is-red-make-cell-1-conditional-formatting-example
Sheet: PD training Matrix

 |  |  |  |  |  |  |  | 1 | "= read and understood"
 |  |  |  |  |  |  |  | 2 | "= competent supervised
 |  |  |  |  |  |  |  | 3 | "= competent unsupervised
Updated DOP |  |  |  |  | Sum Red |  |  |  | 77
 |  |  |  |  | [NAME] |  |  |  | 0
Not issued |  |  |  |  | [NAME] |  |  |  | 8
 |  |  |  |  | Total Required
 |  |  |  |  | % Green
 |  |  | Area | Title | Ref No | V |  | Required | Actual |  | Required | Actual |  | Required | Actual |  |  |  |  | Required | Actual |  | Required | Actual |  | Required | Actual |  | Required | Actual
 |  |  |  |  | DOC1 |  |  | 1
 |  |  |  |  | DOC2 |  |  | 1
 |  |  |  |  | DOC3 |  |  | 1
 |  |  |  |  | DOC4 |  |  | 1
 |  |  |  |  | DOC5 |  |  | 1
 |  |  |  |  | DOC6 |  |  | 1
 |  |  |  |  | [NAME] |  |  | 1
 |  |  |  |  | DOC8 |  |  | 1
 |  |  |  |  | DOC9 |  |  | 1
 |  |  |  |  | DOC10 |  |  | 1
 |  |  |  |  | DOC11 |  |  | 1
 |  |  |  |  | DOC12 |  |  | 1
 |  |  |  |  | [NAME] |  |  | 1
 |  |  |  |  | DOC14 |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1111111111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1111111111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1111111111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1111111111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1111111111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1111111111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1111111111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1111111111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1111111111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1111111111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1111111111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1111111111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1111111111