excel icon set

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
billposter
Posts: 30
Joined: Wed Feb 01, 2017 1:45 pm

What i would like to do when i farm games in to betangle spread sheets is set an icon (directional arrow) with the odds, does any one know a forumlar to do this so when the odds change the arrows chang from amber to green when the odds go up and amber to red when they go down amber been the start point so every time there is an odds change they change colour like you see on the ladder just to give me a visual on what is happening more so for pre match scalping. i have tried and got it half right but not 100% hope i have explained well enough.
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

dogs.JPG
have a look at my greyhound data sheet.
I have used similar icon sets.
If you know about excel you can modify your sheet to suit using mine as an example
You do not have the required permissions to view the files attached to this post.
billposter
Posts: 30
Joined: Wed Feb 01, 2017 1:45 pm

Do the icons set automatic when you input data???
User avatar
Geordie
Posts: 173
Joined: Fri Sep 12, 2014 10:54 am
Location: North East

billposter wrote:
Wed Dec 13, 2017 3:25 am
Do the icons set automatic when you input data???
Yes, it's part of Excel - check out "Conditional Formatting" on the 'Home' tab.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”