https://community.betfair.com/general_betting/go/thread/view/94082/28826913/excel-help---pls-with-sugar-on-topI have a soccer score in excel which I am updating manually.Team A's score in cell [A1]. Team B's score in cell [B1].How do I make a formula in [C1] which automatically will; Turn [C1] into either 1 if [A1] is higher than [B1], turn [C1] into X if [Ahttps://community.betfair.com/general_betting/go/thread/view/94082/28826913/excel-help---pls-with-sugar-on-top?post_id=514740365#514740365I am guessing that dave b's formula he supplied for the original question did not work because the op'sExcel is using a language that is not English. The English uses a comma as a parameter/argument separator and some other languagesuse a semi-colan.Sun, 08 Jan 2012 06:32:46 -0600https://community.betfair.com/general_betting/go/thread/view/94082/28826913/excel-help---pls-with-sugar-on-top?post_id=514739407#514739407It probably depends on which version of Excel you're using as to whether this next bit works.There's a tab at the top called conditional formatting in excel 2007click on D1 and then click on that tab.Select "Highlight cell rules" from the drop down tSun, 08 Jan 2012 05:55:32 -0600https://community.betfair.com/general_betting/go/thread/view/94082/28826913/excel-help---pls-with-sugar-on-top?post_id=514725597#514725597found it, thxSat, 07 Jan 2012 18:18:59 -0600https://community.betfair.com/general_betting/go/thread/view/94082/28826913/excel-help---pls-with-sugar-on-top?post_id=514724155#514724155ie Cell [D1] will light up green if it contains the same content [1] as Cell [C1].Sat, 07 Jan 2012 17:42:15 -0600https://community.betfair.com/general_betting/go/thread/view/94082/28826913/excel-help---pls-with-sugar-on-top?post_id=514723901#514723901dave b / Lori; Is one of you able to solve my final question; I have the following in Cell A1; [3] goals. In Cell B1; [2] goals - which then result in my Cell C1 showing a [1] due to our formula above.In Cell [D1], [E1] and [F1]... i have guessed/staSat, 07 Jan 2012 17:34:40 -0600https://community.betfair.com/general_betting/go/thread/view/94082/28826913/excel-help---pls-with-sugar-on-top?post_id=514723631#514723631I just copied and pasted your formula into Excel and it comes back as text!? As long as it works for you. Cheers.Sat, 07 Jan 2012 17:28:26 -0600https://community.betfair.com/general_betting/go/thread/view/94082/28826913/excel-help---pls-with-sugar-on-top?post_id=514723487#514723487Thank you both. I found out just now that I needed to call formula; =IF(A1>B1;("1");IF(A1=B1;("X");("2"))) Maybe just my setup - but seems to work now, thank you a lot!Sat, 07 Jan 2012 17:24:41 -0600https://community.betfair.com/general_betting/go/thread/view/94082/28826913/excel-help---pls-with-sugar-on-top?post_id=514723201#514723201If that doesn't work click on C1 then go to Tools then Options and make sure the Formulas box is not checked.Sat, 07 Jan 2012 17:18:32 -0600https://community.betfair.com/general_betting/go/thread/view/94082/28826913/excel-help---pls-with-sugar-on-top?post_id=514723113#514723113Right click on C1 and "format cell"See if it's set to "general", if it's not, set it to that.Sat, 07 Jan 2012 17:16:20 -0600https://community.betfair.com/general_betting/go/thread/view/94082/28826913/excel-help---pls-with-sugar-on-top?post_id=514722831#514722831Hmm.. I enter in C1: =IF(A1>B1,"1",IF(A1=B1,"X","2")) after having entered the number 2 in cell A1 and the number 1 in cell B1. I then thought that there would be either 1, X or 2 in C1. But there's only the formula.. written in C1?Sat, 07 Jan 2012 17:09:28 -0600