Makeing a row to be invisible.

[A-Design]

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.

 

[Gord Dibben]

Select row to hide.

Format>Conditional Formatting>Formula is: =$A$2=0

Format>Font>Color.......white

OK your way out.


Gord Dibben Excel MVP

 

[Ragdyer]

Look up "Conditional Formatting" in the Help files.

Then post back with any further questions.

 

[Max]

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

 

[Guest]

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

 

[A-Design]

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]

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]

You're welcome !

 

[Max]

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.