Copy a row from one sheet to another based on the color of a cell

I am hoping I dont have to go into some huge long vba or macro coding to do this. I just need a simple way to say "Hey- this row has a red highlighted cell, so copy that row into the other sheet until it is no longer red"
I have seen tons of code, but nothing has worked for me.
So I have one sheet titled "ST Audit history", and the other titled "Tracking". In the ST Audit history, in colum G starting in row 3 and going down, I have dates that are expired and highlighted in red. I would like the whole row to be copied over to the "Tracking" sheet. If the cell is no longer red in the audit sheet, then i want it to disappear from the tracking sheet. Any ideas? Maybe an "if, then," formula?
Thanks to anyone who can make this simple for me

I was able to get this code to work for 1 row, but I need it to work for all rows from row 3 down. I also need it to disappear once the cell is no longer red, but right now it stays there and the cell just takes the red highlight away. Any help is greatly appreciated

Private Sub Worksheet_Activate()
Cells.Clear
Sheets("ST Audit history").Rows(3).Copy Destination:=Rows(2)
For N = 2 To Sheets("ST Audit history").UsedRange.Rows.Count
If Sheets("ST Audit history").Cells(N, 6).Interior.ColorIndex = 3 Then
Sheets("ST Audit history").Rows(N).Copy Destination:=Rows(UsedRange.Rows.Count + 1)
End If
Next N
End Sub

Any help please? Should I repost this in the VBA forum?