Warning

 

Close

Confirm Action

Are you sure you wish to do this?

Confirm Cancel
Member Login
Site Notices
1/25/2018 7:38:29 AM
Posted: 1/24/2006 3:54:09 AM EST
[Last Edit: 1/24/2006 3:54:28 AM EST by eagle308us]
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?
Link Posted: 1/24/2006 3:56:18 AM EST

You can select the cells you want then right click and select "hide".

Shok
Link Posted: 1/24/2006 3:58:45 AM EST
[Last Edit: 1/24/2006 3:59:19 AM EST by QuantumPion]
www.excelforum.com/

I think you need to make a macro or script to do that but it can be done.
Link Posted: 1/24/2006 3:59:28 AM EST
[Last Edit: 1/24/2006 4:07:48 AM EST by eagle308us]
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?
Link Posted: 1/24/2006 4:25:03 AM EST

Originally Posted By eagle308us:
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.
Top Top