ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I hide a column based on a condition (option not available. (https://www.excelbanter.com/excel-worksheet-functions/9708-how-do-i-hide-column-based-condition-option-not-available.html)

jgentillet

How do I hide a column based on a condition (option not available.
 
I would like a column to be hidden as long as all the values in the cells are
0. When a formula in one the cells in this column is returning a positive
value I'd like the column to reappear. The conditional formatting does give
me access to protection tab of cell format properties.
Using Excel 2003 SP1.


All times are GMT +1. The time now is 05:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com