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 in Computers & Internet ➔ Software
Here is a link with instructions:
http://www.ozgrid.com/VBA/Sort.htm
2007-07-15 23:12:58 · answer #1 · answered by Mickey Mouse Spears 7 · 1⤊ 0⤋
If you want to do this, you'll need to code the thing in VBA.
The usual solution is to take an extra column and use individual numbers in there (1 = red, 2 = green) for example. Then filter on that column.
Otherwise you can get a free download add-in from
http://www.asap-utilities.com/
Which will allow you to filter on colour.
2007-07-16 06:19:59 · answer #2 · answered by lordmoldishorts 2 · 0⤊ 0⤋
Go to Format , conditional formating, this will reveal the different condtion(s) for the color(s).
2007-07-16 12:20:41 · answer #3 · answered by clinky 3 · 0⤊ 0⤋