ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I create an IF function to hide cells in column B IF cells. (https://www.excelbanter.com/excel-programming/314640-how-do-i-create-if-function-hide-cells-column-b-if-cells.html)

nlw2

How do I create an IF function to hide cells in column B IF cells.
 
I need to do the above. I need it to be hidden on the worksheet and for
printing.

Frank Kabel

How do I create an IF function to hide cells in column B IF cells.
 
Hi
you can't :-)

One workaround: Use 'Format - conditional format' and set the font
color to white for specific data.
If you need to hide the rows/columns you may have a look at:
http://www.rondebruin.nl/print.htm#Hide


--
Regards
Frank Kabel
Frankfurt, Germany


nlw2 wrote:
I need to do the above. I need it to be hidden on the worksheet and
for printing.




All times are GMT +1. The time now is 06:58 AM.

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