in the first message you talked about only H2 and now it is I3 to I263
I suppose I3 to I263 is correct where the dates are parked.
in this case open vb editor, click control+R. in the project window go to your file and right click "thisworkbook" and park this event code
Private Sub Workbook_Open()
Dim r As Range, c As Range
ActiveSheet.Cells.Interior.ColorIndex = xlNone
Set r = Range("I3:I263")
For Each c In r
If c > CDate(Date) And c <= CDate(Date + 30) Then
c.EntireRow.Cells.Interior.ColorIndex = 6
ElseIf c > Date + 30 Then
c.EntireRow.Cells.Interior.ColorIndex = 3
taking into account basic colors no. 6 is yellow and 3 is red.