Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim Tim is offline
external usenet poster
 
Posts: 408
Default Conditionally Hiding or Showing the cell content

In the cells c20 to c30 I might have, or might have not some (text) data.
In the adjacent cells d20 to d30 I have a formula showing me some results.
I want that the formula results in cells d20 to d30 to be displayed only if
there is data in the nearby correspondents "c" cells

TIA again and again

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default Conditionally Hiding or Showing the cell content

In D20: =IF(C20="","",formula)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Tim" wrote in message
...
In the cells c20 to c30 I might have, or might have not some (text) data.
In the adjacent cells d20 to d30 I have a formula showing me some results.
I want that the formula results in cells d20 to d30 to be displayed only
if
there is data in the nearby correspondents "c" cells

TIA again and again



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 524
Default Conditionally Hiding or Showing the cell content

Sat, 25 Aug 2007 00:18:00 -0700 from Tim
:
In the cells c20 to c30 I might have, or might have not some (text) data.
In the adjacent cells d20 to d30 I have a formula showing me some results.
I want that the formula results in cells d20 to d30 to be displayed only if
there is data in the nearby correspondents "c" cells


In D20:
=if(isblank(C20),"",formula)
Then click and drag down to D21 through D30.

--
"First prove what you're saying, then whine about it."
-- /The People's Court/
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
  #4   Report Post  
Posted to microsoft.public.excel.misc
Tim Tim is offline
external usenet poster
 
Posts: 408
Default Conditionally Hiding or Showing the cell content

Thank you very much guys.
In fact I put already a formula (as Bob proposed), but I was hoping to
realise the same with any cell conditional formating.

However thanks again

"Stan Brown" wrote:

Sat, 25 Aug 2007 00:18:00 -0700 from Tim
:
In the cells c20 to c30 I might have, or might have not some (text) data.
In the adjacent cells d20 to d30 I have a formula showing me some results.
I want that the formula results in cells d20 to d30 to be displayed only if
there is data in the nearby correspondents "c" cells


In D20:
=if(isblank(C20),"",formula)
Then click and drag down to D21 through D30.

--
"First prove what you're saying, then whine about it."
-- /The People's Court/
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Conditionally Hiding or Showing the cell content

Yes, you can do that. Use "Formula is", rather than "Cell value is", within
CF, & set the font colour to white (or whatever the background colour is),
for the cases you want to hide.
--
David Biddulph

"Tim" wrote in message
...
Thank you very much guys.
In fact I put already a formula (as Bob proposed), but I was hoping to
realise the same with any cell conditional formating.

However thanks again


"Stan Brown" wrote:

In D20:
=if(isblank(C20),"",formula)
Then click and drag down to D21 through D30.


Sat, 25 Aug 2007 00:18:00 -0700 from Tim
:
In the cells c20 to c30 I might have, or might have not some (text)
data.
In the adjacent cells d20 to d30 I have a formula showing me some
results.
I want that the formula results in cells d20 to d30 to be displayed
only if
there is data in the nearby correspondents "c" cells



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
Hiding/Showing Rows on Cell H2 Change Rob Excel Discussion (Misc queries) 9 December 14th 08 02:44 AM
Hiding row base on cell content brownti via OfficeKB.com Excel Discussion (Misc queries) 11 February 14th 07 07:53 PM
Conditionally Hiding Rows Llobid Excel Discussion (Misc queries) 5 April 11th 06 10:56 PM
hiding content when there is a #REF in a cell bobtracey Excel Discussion (Misc queries) 1 April 5th 06 02:47 PM
Hiding Rows Conditionally Mike Hogan Excel Discussion (Misc queries) 2 December 9th 04 11:05 PM


All times are GMT +1. The time now is 12:00 AM.

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"