#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default hide cells

does anyone know if I can hide certain cells until one cell is 'true'.......

--
Mr.B
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default hide cells

Hi,

What do you mean by hide? You can hide rows or columns in Excel but not
cells. You can hide the contents of a cell, in the spreadsheet or on the
Formula bar or in both places.

=IF(A1=TRUE,"Stuff","")

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Mr.B" wrote:

does anyone know if I can hide certain cells until one cell is 'true'.......

--
Mr.B

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default hide cells

You can use conditional formatting to make the colour of the font white (or
whatever your background colour is).
--
David Biddulph

"Mr.B" wrote in message
...
does anyone know if I can hide certain cells until one cell is
'true'.......

--
Mr.B



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
Hide cells Fred Goldman Excel Discussion (Misc queries) 9 November 27th 07 09:41 PM
Hide cells Daniel- Sydney Excel Discussion (Misc queries) 6 January 26th 07 05:14 PM
Want to show/hide cells depending on other cells results Marco Excel Discussion (Misc queries) 0 August 15th 06 06:21 PM
Cannot hide cells craig New Users to Excel 7 May 9th 05 10:11 PM
Cannot hide cells craig Excel Worksheet Functions 4 May 9th 05 09:37 PM


All times are GMT +1. The time now is 08:23 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"