Hide row based on cell value

  • Thread starter Thread starter Munchkin
  • Start date Start date
M

Munchkin

Colum C shows a date. If the date shown is older than 4 years I want the row
to be hidden.

Is it possible to do this?
 
Here's one easy, effective play using a helper col & autofilter ..

Insert a new helper col D, if necessary, next to the dates col C (dates in
col C are presumed real dates recognized by Excel)

Put in D2:
=IF(ISTEXT(C2),"",IF(C2>=DATE(YEAR(TODAY())-4,MONTH(TODAY()),DAY(TODAY())),"x",""))
Copy D2 down to cover the max expected extent of data in col C. Col D flags
directly the results that you're after ("x"), ie where the dates in col C are
NOT older than 4 years (the other way around to look at it)

Anytime that you want to exclude/hide dates in col C older than 4 years ..
Just apply autofilter on col D, choose: x
and that's your baby (the filtered results) !

Aloha? Celebrate it here, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
 
Try the below macro...

Sub HideRows()
For lngRow = 1 To Cells(Rows.Count, 3).End(xlUp).Row
If DateDiff("m", Range("c" & lngRow), Date) > 48 And _
0 + Range("c" & lngRow) <> 0 Then Rows(lngRow).Hidden = True
Next
End Sub

If this post helps click Yes
 
Back
Top