Mea Culpa,
Reorganized version:
http://www.savefile.com/files/1883361
You might also like the alternate method shown:
Requires no formulas, no code, no helper columns,
no conditional formatting and no defined names.
Slight loss in presentation, but big gain in flexibility.