Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding/Showing Rows on Cell H2 Change | Excel Discussion (Misc queries) | |||
Hiding row base on cell content | Excel Discussion (Misc queries) | |||
Conditionally Hiding Rows | Excel Discussion (Misc queries) | |||
hiding content when there is a #REF in a cell | Excel Discussion (Misc queries) | |||
Hiding Rows Conditionally | Excel Discussion (Misc queries) |