I have a spreadsheet that uses different coloured cells to denote different things, these cells also contain a numerical value (different values) that are hyperlinked to different sheets. I want to be able to view just a particular coloured set of cells by selecting that colour. If I use filter, I can only select cell values, if I use find, it will show one cell at a time but not hide the other cells around the one I want.
I am using Microsoft Office 2003, any help you could give me would be most welcome.
Thanks in advance.
2007-07-15
23:08:59
·
3 answers
·
asked by
Anonymous