Results 1 to 3 of 3

Thread: Colour Text based on "Greater than" Value

  1. #1
    Seeker Betting's Avatar
    Join Date
    Jan 2019
    Posts
    8
    Articles
    0
    Excel Version
    2016

    Colour Text based on "Greater than" Value



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 by Betting; 2019-03-13 at 04:45 PM.

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    194
    Articles
    0
    Excel Version
    2019

  3. #3
    Seeker Betting's Avatar
    Join Date
    Jan 2019
    Posts
    8
    Articles
    0
    Excel Version
    2016
    Ok - think I got now.
    Last edited by Betting; 2019-03-13 at 07:10 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •