Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create formula to; sum the lowest 10 cells in a column PCat Excel Worksheet Functions 3 September 22nd 09 04:22 PM
Conditional formatting / Hide-when-Function in a range of 3 cells ran58 Excel Discussion (Misc queries) 2 July 22nd 09 05:24 PM
Create a "cell button" to hide selected cells. Shoolin Patel Excel Worksheet Functions 12 July 30th 07 11:00 AM
how do I update a column and create new rows for new column cells Pete Excel Discussion (Misc queries) 1 June 6th 07 02:02 AM
How to hide running total in successive cells in a column JenniferAnderson Excel Worksheet Functions 3 August 10th 06 10:16 PM


All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"