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.


Wanna Learn wrote:

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

--

Dave Peterson

Thanks Dave Is it possbible to attach a macro to do this?

Dave Peterson" wrote:

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.


Wanna Learn wrote:

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

--

Dave Peterson

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.

Wanna Learn wrote:

Thanks Dave Is it possbible to attach a macro to do this?

Dave Peterson" wrote:

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.


Wanna Learn wrote:

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

--

Dave Peterson


--

Dave Peterson

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

On Jul 6, 2:14 pm, Wanna Learn
wrote:
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