Turn part number in column A green text if conditions are met

[CMHALL]

Hi new user here ,Please could anybody help me with a problem with excel . I will try to explain. I have a excel sheet with a lot of data on in column A I have part numbers In column G is the vendor column is date and column J is the reject or accept column.
What I want to do is when I put a part number into column A the number text will appear as green text if that part number with the same vendor accepted and done in this year has bee done more than 5 times. I hope this makes sense.
Basically if the part number has been entered more than 5 time in a year from same vendor and passed I want it to appear green.
I have attached the workbook that I am using.

[Bernie Deitrick]

Select from A3 to the bottom of column A, select CF, select "New Rule" select "Use a formula to determine which cells to format", and use the formula

=COUNTIFS($A:$A,A3,$G:$G,G3,$I:$I,">=" & EDATE(TODAY(),-12),$J:$J,"Accept")>5

and select the formatting that you want to use.

Note that I have assumed that 'in a year' means 'from one year ago today' and not 'within 2018' If you actually want 2018 only, then change EDATE(TODAY(),-12) to DATE(YEAR(TODAY()),1,1)