yogi_WorkAround For Conditionally Formatting (Flagging) Every Third Instance Of A Student's Name For Disciplining

                                          Google Spreadsheet   Post  #1381
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep 28, 2013

user spencerb (http://productforums.google.com/forum/?zx=kv2v4ugrv7vv#!category-topic/docs/spreadsheets/QZg_pnsCJ1o)
How to Apply Background Color to every 3rd instance of a name
I'm creating a "discipline form" of sorts, and am wanting to come up with a formula that would apply a red background color with white text to a row of of cells (probably only 4 cells across) for every third instance of the name of a student.  

Here's a copy of the form - https://docs.google.com/spreadsheet/ccc?key=0Ap6iyNpVnim9dDVFTVdfUms3cThMT2Y0SENidjdwMHc&usp=sharing

I've highlighted the third instance of a student, just to show you what the highlighting of the row should look like.  And ideally, the formula would allow me to choose a hex color to color the row whatever color it needs to be.

And if a student's name is provided 6 times, it would have 2 rows highlighted red.  9 times, it would have 3 rows highlighted red, and so on...

Thanks for your help!

-----------------------------------------------------------------------------------------------------------------------------------------------------------------