New Posts For Thread: Excel help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/27760513/excel-help-pleaseIn my downloaded p/l column I would like to have any minus figures highlighted in red bold.tiaGGRYou're a fine one to talk of fairy tales, system boy....https://community.betfair.com/general_betting/go/thread/view/94082/27760513/excel-help-please?post_id=498546201#498546201You're a fine one to talk of fairy tales, system boy....Sat, 11 Jun 2011 03:41:05 -0500if you are making so much money, why are you still living with yer mam.don't choke on your porridge goldilocks!!!!https://community.betfair.com/general_betting/go/thread/view/94082/27760513/excel-help-please?post_id=498545913#498545913if you are making so much money, why are you still living with yer mam.don't choke on your porridge goldilocks!!!!Sat, 11 Jun 2011 03:34:01 -0500Morning. Take a look at the darts, son.... You could only dream of stuff like that....https://community.betfair.com/general_betting/go/thread/view/94082/27760513/excel-help-please?post_id=498545825#498545825Morning. Take a look at the darts, son.... You could only dream of stuff like that....Sat, 11 Jun 2011 03:31:52 -0500morning rasp, you throwing any darts today?maybe this week you may hit the board with one of them.50/50 system doing well (send more money), trebled a small bank over 3 months.going live soon!!https://community.betfair.com/general_betting/go/thread/view/94082/27760513/excel-help-please?post_id=498545737#498545737morning rasp, you throwing any darts today?maybe this week you may hit the board with one of them.50/50 system doing well (send more money), trebled a small bank over 3 months.going live soon!!Sat, 11 Jun 2011 03:29:23 -0500morning rasp, you throwing any darts today?maybe this week you may hit the board with one of them.50/50 system doing well (send more money), trebled a small bank over 3 months.going live soon!!https://community.betfair.com/general_betting/go/thread/view/94082/27760513/excel-help-please?post_id=498545725#498545725morning rasp, you throwing any darts today?maybe this week you may hit the board with one of them.50/50 system doing well (send more money), trebled a small bank over 3 months.going live soon!!Sat, 11 Jun 2011 03:29:10 -0500Tighten your what? Could you get any tighter?https://community.betfair.com/general_betting/go/thread/view/94082/27760513/excel-help-please?post_id=498545225#498545225Tighten your what? Could you get any tighter?Sat, 11 Jun 2011 03:14:03 -0500ror10 Jun 11 11:50Joined:23 Oct 08| Topic/replies: 3,078 | Blogger: ror's blogThere's a better way than that without using conditional formatting. If you press ctrl+1, then in advanced formatting settings there are some with red negatives.Or in custohttps://community.betfair.com/general_betting/go/thread/view/94082/27760513/excel-help-please?post_id=498543949#498543949ror10 Jun 11 11:50Joined:23 Oct 08| Topic/replies: 3,078 | Blogger: ror's blogThere's a better way than that without using conditional formatting. If you press ctrl+1, then in advanced formatting settings there are some with red negatives.Or in custoSat, 11 Jun 2011 02:28:58 -0500There's no rigmarole. And your code doesn't solve it, it has to be run each time, and if it's a calculated field it won't automatically change based on the result.Formatting a square so it's red if negative is just a freaking option in the formattinghttps://community.betfair.com/general_betting/go/thread/view/94082/27760513/excel-help-please?post_id=498533749#498533749There's no rigmarole. And your code doesn't solve it, it has to be run each time, and if it's a calculated field it won't automatically change based on the result.Formatting a square so it's red if negative is just a freaking option in the formattingFri, 10 Jun 2011 21:15:26 -0500You only have to write the code once. Then for each P and L download it's just one click instead of all that rigmarole.https://community.betfair.com/general_betting/go/thread/view/94082/27760513/excel-help-please?post_id=498501809#498501809You only have to write the code once. Then for each P and L download it's just one click instead of all that rigmarole.Fri, 10 Jun 2011 13:54:40 -0500WTF? Code? That's a really **** way to do it.You don't need any fancy customisation for this, it's a simple option in the ctrl+1 format box. Format > Numbers; Then format code [$£-809]#,##0.00;[RED]-[$£-809]#,##0.00, or just select currency and tichttps://community.betfair.com/general_betting/go/thread/view/94082/27760513/excel-help-please?post_id=498467437#498467437WTF? Code? That's a really **** way to do it.You don't need any fancy customisation for this, it's a simple option in the ctrl+1 format box. Format > Numbers; Then format code [$£-809]#,##0.00;[RED]-[$£-809]#,##0.00, or just select currency and ticFri, 10 Jun 2011 07:07:22 -0500