Makeing a row to be invisible.

Hi,

Without using VBA, how can I make a row of cells to be invisible base on
value of another cell.
for example: make a row to be invisible (by setting row's text color same
as background color) if another cell's value is equal to zero.

Thanks in advance.

Assuming A1:A10 will house the "control" value (i.e. zero) to make the
corresponding row within B1:E10 appear "invisible"

Select B1:E10 (with B1 active)
Click Format > Conditional Formatting
Use as the cond format formula:
=AND($A1=0,$A1<>"")
Format to mask > OK out

If A3 contains a zero, then B3:E3 will appear "invisible", etc
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"A-Design" <afshinstock@hotmail.com> wrote in message
news:uqgpXc59FHA.1988@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> Without using VBA, how can I make a row of cells to be invisible base on
> value of another cell.
> for example: make a row to be invisible (by setting row's text color same
> as background color) if another cell's value is equal to zero.
>
> Thanks in advance.
>
>

Look up "Conditional Formatting" in the Help files.

Then post back with any further questions.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"A-Design" <afshinstock@hotmail.com> wrote in message
news:uqgpXc59FHA.1988@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> Without using VBA, how can I make a row of cells to be invisible base on
> value of another cell.
> for example: make a row to be invisible (by setting row's text color same
> as background color) if another cell's value is equal to zero.
>
> Thanks in advance.
>

Assuming A1:A10 will house the "control" value (i.e. zero) to make the
corresponding row within B1:E10 appear "invisible"

Select B1:E10 (with B1 active)
Click Format > Conditional Formatting
Use as the cond format formula:
=AND($A1=0,$A1<>"")
Format to mask > OK out

If A3 contains a zero, then B3:E3 will appear "invisible", etc
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"A-Design" <afshinstock@hotmail.com> wrote in message
news:uqgpXc59FHA.1988@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> Without using VBA, how can I make a row of cells to be invisible base on
> value of another cell.
> for example: make a row to be invisible (by setting row's text color same
> as background color) if another cell's value is equal to zero.
>
> Thanks in advance.
>
>

Thank you so much Max.

I have tried to write this condition many times but it didn't work, and now
you solved it!.
Thanks again.


"Max" <demechanik@yahoo.com> wrote in message
news:BA0C61A0-7259-4C7E-A601-603F23416A88@microsoft.com...
> Assuming A1:A10 will house the "control" value (i.e. zero) to make the
> corresponding row within B1:E10 appear "invisible"
>
> Select B1:E10 (with B1 active)
> Click Format > Conditional Formatting
> Use as the cond format formula:
> =AND($A1=0,$A1<>"")
> Format to mask > OK out
>
> If A3 contains a zero, then B3:E3 will appear "invisible", etc
> --
> Rgds
> Max
> xl 97
> ---
> Singapore, GMT+8
> xdemechanik
> http://savefile.com/projects/236895
> --
> "A-Design" <afshinstock@hotmail.com> wrote in message
> news:uqgpXc59FHA.1988@TK2MSFTNGP12.phx.gbl...
>> Hi,
>>
>> Without using VBA, how can I make a row of cells to be invisible base on
>> value of another cell.
>> for example: make a row to be invisible (by setting row's text color
>> same
>> as background color) if another cell's value is equal to zero.
>>
>> Thanks in advance.
>>
>>
>
>

Max,
By using similar method, can I delete or even insert a row or column ? If
yes ,Could you please give me an example?
Thanks.

"Max" <demechanik@yahoo.com> wrote in message
news:BA0C61A0-7259-4C7E-A601-603F23416A88@microsoft.com...
> Assuming A1:A10 will house the "control" value (i.e. zero) to make the
> corresponding row within B1:E10 appear "invisible"
>
> Select B1:E10 (with B1 active)
> Click Format > Conditional Formatting
> Use as the cond format formula:
> =AND($A1=0,$A1<>"")
> Format to mask > OK out
>
> If A3 contains a zero, then B3:E3 will appear "invisible", etc
> --
> Rgds
> Max
> xl 97
> ---
> Singapore, GMT+8
> xdemechanik
> http://savefile.com/projects/236895
> --
> "A-Design" <afshinstock@hotmail.com> wrote in message
> news:uqgpXc59FHA.1988@TK2MSFTNGP12.phx.gbl...
>> Hi,
>>
>> Without using VBA, how can I make a row of cells to be invisible base on
>> value of another cell.
>> for example: make a row to be invisible (by setting row's text color
>> same
>> as background color) if another cell's value is equal to zero.
>>
>> Thanks in advance.
>>
>>
>
>

You're welcome !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"A-Design" <afshinstock@hotmail.com> wrote in message
news:#YcPoe99FHA.2640@tk2msftngp13.phx.gbl...
> Thank you so much Max.
>
> I have tried to write this condition many times but it didn't work, and
now
> you solved it!.
> Thanks again.

"A-Design" wrote:
> By using similar method, can I delete or even insert a row or column ?
> If yes ,Could you please give me an example?

No, formulas / CF wouldn't be able accomplish that. To delete/insert
rows/cols, or even just to hide/unhide rows/cols, we'd need to use
subroutines.
Try a new post in .programming with specifics if you're interested to pursue
this.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--