Spreadsheet: 849847d1700226930-using-icon-sets-for-variances-between-2-data-columns-not-working-review-comparison
Sheet: 2022 vs 2023

2022 & 2023 performance review comparison |  |  |  |  |  |  |  |  |  |  |  |  |  | I don't want to have the variance columns, but put the arrows within the totals columns, as shown by using a symbol in cell O6, but not sure how I do that using the Icon sets conditional formatting?
 |  | 2022 |  |  |  |  |  | 2023 |  |  |  |  |  | 2023 vs 2022
PERFORMANCE REVIEW – QUESTIONNAIRE questions in red only asked in 2023 survey |  | Total BoT & ELT | Total BoT | Total ELT | Average BoT | Average ELT |  | Total BoT & ELT | Total BoT | Total ELT | Average BoT | Average ELT |  | Total BoT & ELT | [NAME] |  | Total BoT | [NAME] |  | Total ELT | [NAME]
PART A: | FOCUS
A1 | The Board meets as often as it needs to be effective | 84 | 57 | 27 | 4.384615384615385 | 4.5 |  | 85 | 57 | 28 | 4.384615384615385 | 4.666666666666667 |  | ▲  85 |  |  | 57 |  |  | 28
A2 | Board agendas reflect strategic plans and priorities | 77.7 | 57 | 27 | 4.207692307692308 | 3.833333333333333 |  | 83 | 58 | 25 | 4.461538461538462 | 4.166666666666667 |  | 83 |  |  | 58 |  |  | 25
A3 | Board meetings are about the right length | 79 | 57 | 27 | 4.153846153846154 | 4.166666666666667 |  | 79 | 53 | 26 | 4.076923076923077 | 4.333333333333333 |  | 79 |  |  | 53 |  |  | 26
A4 | Board members focus on strategic issues and avoid getting into operational/management details | 73.7 | 57 | 27 | 3.976923076923077 | 3.666666666666667 |  | 84 | 59 | 25 | 4.538461538461538 | 4.166666666666667 |  | 84 |  |  | 59 |  |  | 25
A5 | The Board receives adequate material in advance of meetings, in sufficient time and detail, to fulfil its role | 74 | 57 | 27 | 4 | 3.666666666666667 |  | 72 | 49 | 23 | 4.083333333333333 | 3.833333333333333 |  | 72 |  |  | 49 |  |  | 23
A6 | I am always clear what we have agreed at the end of the meeting and minutes confirm this and are translated into actions | 78.8 | 57 | 27 | 4.061538461538461 | 4.333333333333333 |  | 82 | 57 | 25 | 4.384615384615385 | 4.166666666666667 |  | 82 |  |  | 57 |  |  | 25
A7 | I can be myself |  |  |  |  |  |  | 80 | 54 | 26 | 4.5 | 4.333333333333333 |  | 80 |  |  | 54 |  |  | 26
A8 | the organisation embraces all aspects of my identity |  |  |  |  |  |  | 78 | 52 | 26 | 4.333333333333333 | 4.333333333333333 |  | 78 |  |  | 52 |  |  | 26
A9 | I feel there are appropriate mechanisms / forums to contribute my voice |  |  |  |  |  |  | 75 | 49 | 26 | 4.083333333333333 | 4.333333333333333 |  | 75 |  |  | 49 |  |  | 26
PART B: | PERFORMANCE
B1 | All board members make a valuable individual contribution to the work of the organisation | 72.5 | 47.5 | 25 | 3.653846153846154 | 4.166666666666667 |  | 77 | 53 | 24 | 4.076923076923077 | 4 |  | 77 |  |  | 53 |  |  | 24
B2 | The Board has the appropriate mix of skills and attributes to adequately address all its governance functions | 79.5 | 55.5 | 24 | 4.269230769230769 | 4 |  | 80 | 55 | 25 | 4.230769230769231 | 4.166666666666667 |  | 80 |  |  | 55 |  |  | 25
B3 | The Board enables the delivery of strategic objectives | 75.7 | 52.7 | 23 | 4.053846153846154 | 3.833333333333333 |  | 83 | 56 | 27 | 4.307692307692307 | 4.5 |  | 83 |  |  | 56 |  |  | 27
B4 | Board members demonstrate respect for one another and diversity of opinions as well as frank and open discussion and these are included in the decision-making process | 77 | 52 | 25 | 4 | 4.166666666666667 |  | 81.5 | 56.5 | 25 | 4.346153846153846 | 4.166666666666667 |  | 81.5 |  |  | 56.5 |  |  | 25
B5 | The Board has a clear, agreed and effective approach to supporting equality, diversity and inclusion throughout the organisation and in its own practice |  |  |  |  |  |  | 80 | 55 | 25 | 4.230769230769231 | 4.166666666666667 |  | 80 |  |  | 55 |  |  | 25
B6 | The Board acts with integrity. It adopts values, applies ethical principles to decisions and creates a welcoming and supportive culture which helps achieve the organisation's purposes |  |  |  |  |  |  | 83 | 56 | 27 | 4.307692307692307 | 4.5 |  | 83 |  |  | 56 |  |  | 27
PART C: | PROCESS
C1 | All points of view, including those of ELT attending, are taken into account before the Board reaches a decision | 77 | 54 | 23 | 4.153846153846154 | 3.833333333333333 |  | 86 | 60 | 26 | 4.615384615384615 | 4.333333333333333 |  | 86 | 9 |  | 60 |  |  | 26
C2 | The [NAME] guides the meeting effectively and clarifies expectations | 84.5 | 56.5 | 28 | 4.708333333333333 | 4.666666666666667 |  | 85 | 58 | 27 | 4.461538461538462 | 4.5 |  | 85 | 0.5 |  | 58 |  |  | 27
[NAME] | The Board carefully selects and inducts new board members | 78 | 55 | 23 | 4.230769230769231 | 3.833333333333333 |  | 83 | 61 | 22 | 4.692307692307693 | 3.666666666666667 |  | 83 | 5 |  | 61 |  |  | 22
PART D: | RELATIONSHIPS AND ROLES
D1 | The Board shares a clear view about the future direction of the organisation | 59.5 | 41.5 | 18 | 3.192307692307693 | 3 |  | 71.5 | 49.5 | 22 | 3.807692307692307 | 3.666666666666667 |  | 71.5 | 12 |  | 49.5 |  |  | 22
D2 | There is candour/trust between board members | 77 | 53 | 24 | 4.076923076923077 | 4 |  | 81 | 57 | 24 | 4.384615384615385 | 4 |  | 81 | 4 |  | 57 |  |  | 24
D3 | There is candour/trust between board members and Chief Executive | 79 | 54 | 25 | 4.153846153846154 | 4.166666666666667 |  | 85.5 | 59.5 | 26 | 4.576923076923077 | 4.333333333333333 |  | 85.5 | 6.5 |  | 59.5 |  |  | 26
D4 | There is candour/trust between board members and ELT | 77 | 53 | 24 | 4.076923076923077 | 4 |  | 83 | 58 | 25 | 4.461538461538462 | 4.166666666666667 |  | 83 | 6 |  | 58 |  |  | 25