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