Makeing a row to be invisible.

A

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.
 
G

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
 
R

Ragdyer

Look up "Conditional Formatting" in the Help files.

Then post back with any further questions.
 
M

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
 
M

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
 
A

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

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.
 
M

Max

A-Design said:
By using similar method, can I delete or even insert a row or column ?
If yes ,Could you please give me an example?
Click to expand...

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.
 
Top