Hi,

Not with a format but you can do it with event code like this. Right click
your sheet tab, view code and paste the code below in. As soon as a value
10 is entered in column D then the row is hidden.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Or IsEmpty(Target) Then Exit Sub
If Not Intersect(Target, Range("D:D")) Is Nothing Then
If IsNumeric(Target) And Target.Value 10 Then
Target.EntireRow.Hidden = True
End If
End If
End Sub

Mike

"Tracy" wrote:

Is there a way to format a worksheet to automatically hide rows if a certain
cell = a certain number?
--
Tracy