New Posts For Thread: Excel Help (Conditional Formatting)https://community.betfair.com/chit_chat/go/thread/view/94038/31550853/excel-help-conditional-formattingI'm struggling with this one and I can't seem to find the answer online.ExampleA1=100 / B1=A1-10 (90) / C1=B1-0.1 (89.9) / D1=C1-9.9 (80)E1 is a manual daily input and is set up for CONDITIONAL FORMATTING as follows:Greater Than A1 = RED (Background)It's has taken a few hours to build but all appears to be perfect and updating exactly as I would have wished. So relieved, thanks again Charlie!https://community.betfair.com/chit_chat/go/thread/view/94038/31550853/excel-help-conditional-formatting?post_id=557644207#557644207It's has taken a few hours to build but all appears to be perfect and updating exactly as I would have wished. So relieved, thanks again Charlie!Sun, 28 Jul 2019 13:20:47 -0500Well done Aspro. It's useful to learn the difference. You can also use mixed addressing such as $A1 (when the row will change but not the column) or A$1 when the column will change but not the row. In your case $A1 is what you'd need. Just play arounhttps://community.betfair.com/chit_chat/go/thread/view/94038/31550853/excel-help-conditional-formatting?post_id=557642525#557642525Well done Aspro. It's useful to learn the difference. You can also use mixed addressing such as $A1 (when the row will change but not the column) or A$1 when the column will change but not the row. In your case $A1 is what you'd need. Just play arounSun, 28 Jul 2019 08:51:09 -0500I'll test that out a little later Charlie, but I can now see what benefits both formats would have. An unexpected additional lesson learned.https://community.betfair.com/chit_chat/go/thread/view/94038/31550853/excel-help-conditional-formatting?post_id=557642467#557642467I'll test that out a little later Charlie, but I can now see what benefits both formats would have. An unexpected additional lesson learned.Sun, 28 Jul 2019 08:44:57 -0500Pressing the F4 key normally swaps between absolute and relative addressing but I can't test it because my function keys are full of gung thanks to spilling red wine, beer and other stuff on them!https://community.betfair.com/chit_chat/go/thread/view/94038/31550853/excel-help-conditional-formatting?post_id=557642429#557642429Pressing the F4 key normally swaps between absolute and relative addressing but I can't test it because my function keys are full of gung thanks to spilling red wine, beer and other stuff on them!Sun, 28 Jul 2019 08:39:40 -0500Excellent Charlie, I think you may have hit the nail on the head! I'll be back if I have further problems, but this is looking promising. Thanks for the input guys!As for your point dave, that is the theory I'm about to test nowhttps://community.betfair.com/chit_chat/go/thread/view/94038/31550853/excel-help-conditional-formatting?post_id=557642403#557642403Excellent Charlie, I think you may have hit the nail on the head! I'll be back if I have further problems, but this is looking promising. Thanks for the input guys!As for your point dave, that is the theory I'm about to test nowSun, 28 Jul 2019 08:34:54 -0500Aspro just get rid of the dollar signs (to make it relative addressing rather than absolute).https://community.betfair.com/chit_chat/go/thread/view/94038/31550853/excel-help-conditional-formatting?post_id=557642335#557642335Aspro just get rid of the dollar signs (to make it relative addressing rather than absolute).Sun, 28 Jul 2019 08:20:44 -0500ok if I pick a cell and go to the conditional formatting icon, click on the "greater than" option and put in "=A1" then that cell will refer to cell A2 if I copy it down a row.https://community.betfair.com/chit_chat/go/thread/view/94038/31550853/excel-help-conditional-formatting?post_id=557642317#557642317ok if I pick a cell and go to the conditional formatting icon, click on the "greater than" option and put in "=A1" then that cell will refer to cell A2 if I copy it down a row.Sun, 28 Jul 2019 08:18:41 -0500Yep, that's how it workshttps://community.betfair.com/chit_chat/go/thread/view/94038/31550853/excel-help-conditional-formatting?post_id=557642277#557642277Yep, that's how it worksSun, 28 Jul 2019 08:11:03 -0500I think that's right... let's just check it, brbhttps://community.betfair.com/chit_chat/go/thread/view/94038/31550853/excel-help-conditional-formatting?post_id=557642267#557642267I think that's right... let's just check it, brbSun, 28 Jul 2019 08:09:32 -0500No, that doesn't work. To get that to work I just ensure my cursor is clicked in the format box and then click on A1 and I get the > $A$1 come up and it sets correctlyhttps://community.betfair.com/chit_chat/go/thread/view/94038/31550853/excel-help-conditional-formatting?post_id=557642261#557642261No, that doesn't work. To get that to work I just ensure my cursor is clicked in the format box and then click on A1 and I get the > $A$1 come up and it sets correctlySun, 28 Jul 2019 08:08:41 -0500