TJ,

If they are hidden using hide rather than filters, then a macro like this
will shade the hidden rows:

Sub NewSub()
Application.ScreenUpdating = False
Cells.Interior.ColorIndex = 3
Cells.SpecialCells(xlCellTypeVisible).Interior.Col orIndex = xlNone
End Sub

HTH,
Bernie
MS Excel MVP


"TJ" wrote in message
...
How can I set up my worksheets so that rows that are hidden will be shaded
in
if they are unhidden?