Hi there,
I have a RAG (Red, Amber, Green) analysis based on simple conditional formatting rules, where you are required to input a value 1 to 3 depending on a pre-evaluated score; 1 = Red, 2= Amber and 3=Green.
I was wondering, whether you can apply a more merged approach, like a heat map and so the table isn't so rigid and you get a colour contrast going from one cell to another cell and you wouldn't see any grid lines. Is this achievable in excel 2016?
Regards
Ben
<colgroup><col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;">
<col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;">
<col width="51" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;" span="5">
<tbody>
</tbody>
I have a RAG (Red, Amber, Green) analysis based on simple conditional formatting rules, where you are required to input a value 1 to 3 depending on a pre-evaluated score; 1 = Red, 2= Amber and 3=Green.
I was wondering, whether you can apply a more merged approach, like a heat map and so the table isn't so rigid and you get a colour contrast going from one cell to another cell and you wouldn't see any grid lines. Is this achievable in excel 2016?
Regards
Ben
| A | B | C | D | E | F | |
| 1 | Area | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| 2 | Area 1 | 1 | 2 | 2 | 3 | 3 |
| 3 | Area 2 | 2 | 3 | 2 | 3 | 3 |
| 4 | Area 3 | 2 | 2 | 3 | 3 | 3 |
| 5 | Area 4 | 2 | 2 | 3 | 3 | 3 |
| 6 | Area 5 | 2 | 1 | 1 | 2 | 3 |
| 7 | Area 6 | 2 | 2 | 2 | 2 | 2 |
