I have created an excel database with all of the football games I have been too. In one column I have the home score and the next the away score i.e 1.0, 2,2, 0,2 etc
I have created a conditional format so that the colour changes to reflect home win, away win or draw. What I would like to know is how to do it over the complete range of vertical scores. How do I replicate that formatting option over many results.
Thanks in anticipation.