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
Bookmarks