General Betting
There is currently 1 person viewing this thread.
I've also posted this on racing, not sure which would get most replies
hi 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 W the result of the formula
and I want to add to column W a formula that would highlight cells ( say with a colour ) to lay top 26.9% of horses under a variable price in J e.g 15.0 but not in my top 26.9 of ranking
hope that is clear...lol
please explain in detail because I am new to this
many thanks in advance
dave
hi 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 W the result of the formula
and I want to add to column W a formula that would highlight cells ( say with a colour ) to lay top 26.9% of horses under a variable price in J e.g 15.0 but not in my top 26.9 of ranking
hope that is clear...lol
please explain in detail because I am new to this
many thanks in advance
dave
sort by:
Show
per page
Replies: 1
|
By:
in X1 PUT 15
in Y1 PUT 26.9 in 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 chose |