shadow12345
Well-known Member
- Joined
- May 10, 2004
- Messages
- 1,238
what i want to do is colour the numbers in the list as the value changes, i would use conditional format but i need to have 4 colours
blank - no colour
1 = red
2 = blue
3 = green
4 = yellow
Any idea ?
blank - no colour
1 = red
2 = blue
3 = green
4 = yellow
Any idea ?
TSG Ticklist.xls | ||||||
---|---|---|---|---|---|---|
D | E | F | G | |||
1 | Alan Barnett | Kuldeep Dhanda | Katie Cotton | Robin Walker | ||
2 | 3 | 1 | 3 | 4 | ||
3 | 2 | 4 | 4 | |||
4 | 4 | 4 | 4 | |||
5 | 3 | 4 | 4 | |||
6 | 3 | 4 | 4 | |||
7 | 3 | 4 | 4 | |||
8 | 3 | 4 | 4 | |||
CTM |