Unhide row if...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I have the following formula
=IF($B$50="Product Number",TRUE,"")
what I want to do is if the above formula is true then I want row 51 and row
52 to automatically unhide . Thanks
 
Formulas can't do this kind of thing. For the most part, they return values to
the cell that holds that formula.

Maybe you can use the same kind of formula on the other rows, then use
data|filter|autofilter to hide/show the rows that you want.
 
To insert the formula or to do the filtering or what?

I guess you could if you wanted.

Start by recording a macro and reviewing that code.
 
One way to simulate this, i.e. to hide/unhide the contents of row 51
and 52 (not the same as hiding the rows themselves) is to apply
conditional formatting to rows 51 & 52 such that if the formula is
FALSE then use a white foreground colour on a white background. All
the cells in those rows would appear empty until the formula gave a
TRUE result, but the values could still be seen if, for example, you
highlighted the range.

Just a thought ...

Hope this helps.

Pete
 
Back
Top