The format code is


Sub highlight()
    Range("A12:F12").Select
    Selection.FormatConditions.Delete
    Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=$A$6=$E$12"
    Selection.FormatConditions(1).Interior.ColorIndex = 27
End Sub

I just need this to apply to every row from a12:f12 to a:512 to f512. I cant drag format since it needs to apply to individual row