Excel Formula RRS feed

  • Question

  •  How do you write a formula for hiding a row if the value in a cell is greater than a specified number?  Ex. IF C5 >=9 then I want the row to be hidden.  To select a row: SHIFT+SPACEBAR To tell hide the row the series would then be Alt+O then Alt+R then Alt+H     However, I do not know how to put that into a formula.  I have (If c5>=5, ???, ""). Please assist me in writing the code.
    Wednesday, February 4, 2009 3:34 PM

All replies

  • Write this VBA code for controlling C5 cell value

    If Sheet2.Range("C5").Value >= 5 Then
            Sheet2.Rows("5:5").Hidden = True
            Sheet2.Rows("5:5").Hidden = False
    End If
    Thursday, February 12, 2009 11:48 AM