Matching data with 90 days from date

[psrs0810]

I have two sets of data – on sheet one there is a unique # and a date. On sheet two, I will have a listing of unique # and dates.
What I am trying to do is identify every time there is a unique # on sheet one to take the date next to it and identify any other rows where there is a match or within 90 days of the sheet 1 date.

Ie
Sheet 1 column A – 220302 Column B 4/22/2016
Sheet 2 will have a listing of numbers and dates – same columns
I need to find all rows where there is a match with the same number (220302) and 90 days out

 

[JLGWhiz]

Sub hiLight()
Dim sh1 As Worksheet, sh2 As Worksheet, c As Range
Set sh1 = Sheets(1)
Set sh2 = Sheets(2)
    For Each c In sh2.Range("B1", sh2.Cells(Rows.Count, 2).End(xlUp))
        If c.Value = sh1.Range("B1").Value + 90 And c.Offset(, -1).Value = sh1.Range("A1").Value Then
            c.Interior.Color = vbYellow
        End If
    Next
End Sub

or

In C1 and drag down.

=IF(AND(A1=Sheet1!$A$1,B1=Sheet1!$B$1+90),"Yes","")