Results 1 to 4 of 4

Conditional Referencing Cell Ranges to avoid Conditional Formatting Cells Indvidually?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-11-2011
    Location
    London England
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    157

    Question Conditional Referencing Cell Ranges to avoid Conditional Formatting Cells Indvidually?

    I have a spreadsheet that I have setup to determine what is referred to as side value in gambling terms for the English Premiership. I have attached a values only copy of it to demonstrate what I am trying to and effectively automate, which I think may be able to be done through conditional formatting.

    Essentially all of the other figures on the spreadsheet are either calculated (in the full workbook) through a solver model, formula or in the case of the odds are copied in from another workbook. This particular sheet was just based on the last 100 matches and not the full seasons results in terms of percentages.

    What I am trying to do is in the case of home winning % (column G), where this exceeds home winning odds% (in this case from Bet365 and in column K) - hence creating a side value (spreadsheet model calculates chance of outcome occurring odds exceeding bookmaker odds for outcome occurring) - I would want to highlight the percentage in column G yellow, and the odds in column K another colour (in this case magenta). Can this be done through conditional formatting? In this case I would also like to tie together columns I and L, and also H and M (for the other two possible outcomes). I'm figuring that if this can't be done through conditional formatting, I could probably do this via a Macro that I wouldn't be adverse to.

    Is this possible to do in columns rather to do each cell individually (for the reasons laid out in post 3 - sorry I am editing this from a couple of days after the original post to try and improve the clarity).

    I know I could do this manually (e.g. as I have done here) but it would just be a lot easier if I could automate this and it would eliminate potential mistakes.

    Thanks in advance for any advice,

    2011_2012 Last 100 Snapshot.xls
    Last edited by mrvp; 05-15-2012 at 03:59 PM. Reason: Possibly more appropriate title?

Thread Information

Users Browsing this Thread

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

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