Column1 | Home | Column2 | Away | Total Goals |
Apr 1, 7:00pm | Chambly | 6-2 | Belfort | 8 |
Apr 1, 7:00pm | Bourg-en-Bresse | 3 - 0 | Ajaccio | 3 |
Apr 1, 7:00pm | Créteil | 0 - 3 | Clermont | 3 |
Apr 1, 7:00pm | Tours | 2-1 | Brest | 3 |
Apr 1, 7:00pm | Lens | 3 - 0 | Auxerre | 3 |
Apr 1, 7:00pm | Colmar | 1-1 | Dunkerque | 3 |
Apr 1, 7:00pm | Consolat Marseille | 0 - 3 | Avranches | 3 |
Apr 1, 7:00pm | Luçon | 0 - 3 | Amiens SC | 3 |
Apr 1, 7:00pm | Le Havre | 2 - 0 | Laval | 2 |
In the table above I am looking to highlight the teams whose matches have scored more than 3 goals. The only teams this would apply to would be Chambly and Belfort.
What is the best formula to use - basically I need something that goes likes if total goals more than 3, change font colour in "home" and "away" cells to red.
There is probably a very simple way of doing this apologies if so!
Last edited: