hi yes striding read through some of the stuff thanks and the colours are top 26.9% green brightest best and bottom 29% pink darkest being worst,they are done through conditional formatting but wrote in code, I think from what you say that I need ag to have the formula for the conditional formatting as an extra rule to highlight lays

you need to be very specific what you actually want and where, obviously i have seen the sheet now but i can't see from the screen shot where everything is, ie the columns needed in a function to determine the bet outcome.

what do you want the sheet to select backs/lays/no bets ?

what exactly do you want highlighted on the sheet, horses name or just the back/lay/no bet column


it's very difficult indeed for someone from afar to try and work on a sheet they have not got in front of them.

the first thing is to get the formula right so you dont have to pick the bets manually from the data on the screen, you want a column that tells you what you are to do on each selection?

is this right?

hi striding,
I want the sheet to highlight lay bets
top 26.9 at odds of less than 16.0 ( column J )
and not in top ( top = 1) 26.9% of column AG
the cell to be highlighted orange

first thing to do

what are the specific rules of your sheet
when do you want to lay/back or perhaps do nothing

then you can see what columns are needed in the formula to work out your bets

need this info before anything else

goodyd will have to leave this soon but when you have time


try and leave the following on here for me to look at later, probably this evening.

1.) what are the rules of your sheet

ie i want to back when so and so equals this or that etc

i want to lay when etc etc

i want to not bet when etc etc

then i need to know each column where the data needed for the forumla is


finally where do you want the backs/lays/no bets (only 1 column is needed, a different colour can be applied on each outcome.

try and do this and i'm sure we can get this sorted

at the moment i've not got the whole picture

if i had the sheet in front of me would probably take 10 mins but need everything clearly stated.

ok lay bets only i see

so you just need lay bets identified orange if lay if not leave alone

which column is the lay bet to be put in w?

I wanted to put it in W because it is next to betfair prices but when I try it says part of an array, so look like I might be best with AG

you know you bet when your percentages are different to the actual market rank/runners

need to compare the 2 so where is the actual market/no of runners in your sheet?

in my table example i used i had 'my rank' and 'actual rank'

where is actual rank in your data

no I don't compare I just use my ratings and compare against the odds,
actual market is I that is the latest price,
number of runners is in A43 but that changes with each race

or is column j the top 26.9 (actual) and then you need to filter out the odds you want ie less than 16?

ok mate