Can I conditionally format the text of a cell based on values of another cell?
I'm using Numbers 3.5.3 to create a tournament bracket (similar concept to a March Madness bracket, but a different sport).
Here is how the bracket looks at the start:
And here is how it would look after the first two rounds:
The bracket is filled out automatically based upon inputs into a different sheet. What I want to happen is that as winners advance, their name is made bold and the losers name is "faded" (i.e. changed from black to a shade of grey). For example, in the second image, you can see that in match 1, Gregory Viloria (B8) beat Mateo Sanchez (B6) by a score of 18 to 5 (F8 and F6), and advanced to round 2 (I8) to meet Ricky Landeros (I9). Once this happens, is there a way I can make B8 automatically go bold and B6 automatically fade? And, obviously, I want to apply this same thing to the rest of the bracket.
Usually a combination of googling and banging my head against the wall helps me figure these kinds of things out, but this one has me stumped. Thanks for any help you can provide.
Early 2011 MacBook Pro OSX
Yosemite 10.10.4
2.3 GHz Intel Core i5
4 GB 1333 MHz DDR3
OS X Yosemite (10.10.4), Numbers 3.5.3