I have a very large spreadsheet which looks up a number of different other tabs to return the project someone is working on across the day. I'd like to colour the different projects and I could use conditional formatting however there are around 50 different projects and I'd like to find a way of doing that quicker - especially as the end client may want to reorganise the colours!
I had the idea of setting up some form of reference table such as the one below then using a module to colour code them however I became stuck at that point
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
To help - the table I'm trying to colour looks like this. Each letter corresponds to a project and is calculated using a formula.
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
Many thanks
I had the idea of setting up some form of reference table such as the one below then using a module to colour code them however I became stuck at that point
Ref | Colour |
Project A | 1 |
Project B | 2 |
Project C | 3 |
Project D | 4 |
Project E | 5 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
To help - the table I'm trying to colour looks like this. Each letter corresponds to a project and is calculated using a formula.
Person ref | 08:00 | 08:30 | 09:00 | 09:30 | 10:00 | 10:30 | 11:00 |
12345 | A | A | A | B | B | B | B |
22334 | B | C | C | C | D | E | E |
12533 | D | D | E | A | A | A | A |
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
Many thanks