Dave Donut
New Member
- Joined
- Dec 19, 2012
- Messages
- 27
- Office Version
- 365
- Platform
- MacOS
I have used conditional formatting to aid sorting in a sheet. I have colour coded if a certain word appears in cells in a column. I have then sorted by the colours. This has worked fine and the sorting and the colour coding are very useful.
However, the colour coded cells contain a lot of information, which I need to be able to read, and are quite large and the coloured cells use loads of printer ink.
I thought that I could have a similar effect by having a narrow column alongside which could be coloured instead of the large cells, but would use a fraction of the ink.
Is there a way that this could be done.
Thanks.
However, the colour coded cells contain a lot of information, which I need to be able to read, and are quite large and the coloured cells use loads of printer ink.
I thought that I could have a similar effect by having a narrow column alongside which could be coloured instead of the large cells, but would use a fraction of the ink.
Is there a way that this could be done.
Thanks.