New Posts For Thread: excel formula helphttps://community.betfair.com/general_betting/go/thread/view/94082/29919171/excel-formula-helpI've also posted this on racing, not sure which would get most replieshi in excel I have column D that has runners,column J that has betfair prices, column AG my own rankings from my ratings, rankings top is 1 and bottom = number of runners column Win X1 PUT 15in Y1 PUT 26.9in W2 PUT:=IF(AND(J2 < $X$1, AG2 > $Y$1), "LAY ME", "") Use conditional formatting on column W to format all cells which contain "LAY ME" to whatever colour you chosehttps://community.betfair.com/general_betting/go/thread/view/94082/29919171/excel-formula-help?post_id=532060473#532060473in X1 PUT 15in Y1 PUT 26.9in W2 PUT:=IF(AND(J2 < $X$1, AG2 > $Y$1), "LAY ME", "") Use conditional formatting on column W to format all cells which contain "LAY ME" to whatever colour you choseTue, 07 May 2013 08:21:00 -0500I've also posted this on racing, not sure which would get most replieshi in excel I have column D that has runners,column J that has betfair prices, column AG my own rankings from my ratings, rankings top is 1 and bottom = number of runners column Whttps://community.betfair.com/general_betting/go/thread/view/94082/29919171/excel-formula-help?post_id=532055749#532055749I've also posted this on racing, not sure which would get most replieshi in excel I have column D that has runners,column J that has betfair prices, column AG my own rankings from my ratings, rankings top is 1 and bottom = number of runners column WTue, 07 May 2013 02:47:29 -0500