Posted: 1/24/2006 4:54:09 AM EDT
|
I have a Excel file that I want to color-code. Say 5 different colors. Is there a way to hide all cells of a certain color? |
|
www.excelforum.com/ I think you need to make a macro or script to do that but it can be done. |
|
I should have been more specific. The colored cells are going to be mixed togeather. It would be easier if I could color all related cells, say RED, then be able to hide all the other colors but leave the RED cells. I would rather be able to do it with a command than pick each cell. Is this possible? |
yes, but you will need to program a script to do it, as excel has limited cell coloring functionality. You can try messing with the Conditional Formatting function, under the Format menu, but in order to hide/unhide cells with a specfic color you will need to make a script. |