Colour Text based on "Greater than" Value

Betting

New member
Joined
Jan 3, 2019
Messages
8
Reaction score
0
Points
0
Excel Version(s)
2016
Column1HomeColumn2AwayTotal Goals
Apr 1, 7:00pmChambly6-2Belfort8
Apr 1, 7:00pmBourg-en-Bresse3 - 0Ajaccio3
Apr 1, 7:00pmCréteil0 - 3Clermont3
Apr 1, 7:00pmTours2-1Brest3
Apr 1, 7:00pmLens3 - 0Auxerre3
Apr 1, 7:00pmColmar1-1Dunkerque3
Apr 1, 7:00pmConsolat Marseille0 - 3Avranches3
Apr 1, 7:00pmLuçon0 - 3Amiens SC3
Apr 1, 7:00pmLe Havre2 - 0Laval2


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:
Ok - think I got now.
 
Last edited:
Back
Top