VBA/Excel If...Then...ElseIf...Else Statement copy down column issue

Okay, I have the statement figured out, it works just how I need it to. When I run it, it pretty much looks for the Interior.Color and if it matches it gives me the Text value of said cell color. How do I copy and paste this If Statement down the entire column as long as there's data?

I do not know the VBA version for this. So the VBA Code I have looks like this:

If Range("F2").Interior.Color = 255 Then
Range("AE2") = "Red"
ElseIf Range("F2").Interior.Color = 65252 Then
Range("AE2") = "Green"
Else
Range("AE2") = "New"
End If

I want that entire statement to be copied down column AE until there's no data in column F (Copy/Paste) but it changes accordingly, and follows the cells down.

Hopefully I'm making sense.

Thank you