Jeff
You may get away with a filter, either auto or advanced to hide rows.
Or you may need VBA code, either event or menu/button driven.
Sub Hide_Rows()
'using set column A
Dim RngCol As Range
Dim i As Range
Set RngCol = Range("A1", Range("A" & Rows.Count). _
End(xlUp).Address)
For Each i In RngCol
If i.Value = "yours" Then _
i.EntireRow.Hidden = True
Next i
End Sub
In any case, if you're wondering, hiding a row is not a feature of Conditional
Formatting.
Gord Dibben Excel MVP
On Mon, 15 Aug 2005 15:33:03 -0700, Looney
wrote:
Is it possible to hide a row based upon a value one of the columns?
Thank you.
Jeff R.
|