In the attached sheet named '2014-2' are team scores. I would like to automatically color any team losses in red. The attached table has team losses done manually.
Attempted to do this using conditional formatting but was unable. Hope someone can help.
P.S. It should also work when items toward the bottom are updated. (i.e. 213:229).