+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting - Compare 2 cells with betting odds.

  1. #1
    Registered User
    Join Date
    10-26-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    excel ( for mac ) 2008
    Posts
    27

    Question Conditional Formatting - Compare 2 cells with betting odds.

    Hi all I have a problem trying to work out how to set up the right Conditional Formatting formula for this problem

    essentially i only need to compare cell A1 with B1.

    They both have betting odds in them.

    The odds actually represent probably (worked out by 1/cell value) --- (i.e. $2.00 = 1/2 = 0.5 Probability)

    I want cell B1 to highlight when the PROBABILITY is greater than 0.1 to that of cell A1.

    Hopefully someone can help thanks!

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Conditional Formatting - Compare 2 cells with betting odds.

    So in A1 you have $1.20 and in B1 you have $1.00

    1/1.2 = .8333
    1/1 = 1

    so 1 is more than 0.1 more than 0.83333

    Is this the logic?

    if so use this

    =1/B1-1/A1>0.1
    Happy with my advice? Click on the * reputation button below

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Extracting Text As A Number in a Betting Odds
    By kyjae in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-16-2016, 03:02 PM
  2. Conditional formatting to compare a cell to 120 cells
    By derrickrose2 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-05-2015, 02:41 PM
  3. How to calculate Bookmaker real odds (odds less commission) in Excel 2013 ?
    By sbeekallan in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-09-2015, 08:43 AM
  4. Betting odds conversion from fractions to percentages
    By gbilic in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-04-2013, 11:03 AM
  5. Replies: 3
    Last Post: 08-31-2011, 09:11 AM
  6. Formula required to calculate betting odds/returns
    By jonrayworth in forum Excel General
    Replies: 0
    Last Post: 07-13-2010, 08:14 AM
  7. betting odds combinations,
    By JOOJOHN in forum Excel General
    Replies: 2
    Last Post: 02-14-2009, 10:17 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1