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